{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### 读入数据"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "import numpy as np\n",
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Brand</th>\n",
       "      <th>Store Number</th>\n",
       "      <th>Store Name</th>\n",
       "      <th>Ownership Type</th>\n",
       "      <th>Street Address</th>\n",
       "      <th>City</th>\n",
       "      <th>State/Province</th>\n",
       "      <th>Country</th>\n",
       "      <th>Postcode</th>\n",
       "      <th>Phone Number</th>\n",
       "      <th>Timezone</th>\n",
       "      <th>Longitude</th>\n",
       "      <th>Latitude</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Starbucks</td>\n",
       "      <td>47370-257954</td>\n",
       "      <td>Meritxell, 96</td>\n",
       "      <td>Licensed</td>\n",
       "      <td>Av. Meritxell, 96</td>\n",
       "      <td>Andorra la Vella</td>\n",
       "      <td>7</td>\n",
       "      <td>AD</td>\n",
       "      <td>AD500</td>\n",
       "      <td>376818720</td>\n",
       "      <td>GMT+1:00 Europe/Andorra</td>\n",
       "      <td>1.53</td>\n",
       "      <td>42.51</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Starbucks</td>\n",
       "      <td>22331-212325</td>\n",
       "      <td>Ajman Drive Thru</td>\n",
       "      <td>Licensed</td>\n",
       "      <td>1 Street 69, Al Jarf</td>\n",
       "      <td>Ajman</td>\n",
       "      <td>AJ</td>\n",
       "      <td>AE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>GMT+04:00 Asia/Dubai</td>\n",
       "      <td>55.47</td>\n",
       "      <td>25.42</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Starbucks</td>\n",
       "      <td>47089-256771</td>\n",
       "      <td>Dana Mall</td>\n",
       "      <td>Licensed</td>\n",
       "      <td>Sheikh Khalifa Bin Zayed St.</td>\n",
       "      <td>Ajman</td>\n",
       "      <td>AJ</td>\n",
       "      <td>AE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>GMT+04:00 Asia/Dubai</td>\n",
       "      <td>55.47</td>\n",
       "      <td>25.39</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Starbucks</td>\n",
       "      <td>22126-218024</td>\n",
       "      <td>Twofour 54</td>\n",
       "      <td>Licensed</td>\n",
       "      <td>Al Salam Street</td>\n",
       "      <td>Abu Dhabi</td>\n",
       "      <td>AZ</td>\n",
       "      <td>AE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>GMT+04:00 Asia/Dubai</td>\n",
       "      <td>54.38</td>\n",
       "      <td>24.48</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Starbucks</td>\n",
       "      <td>17127-178586</td>\n",
       "      <td>Al Ain Tower</td>\n",
       "      <td>Licensed</td>\n",
       "      <td>Khaldiya Area, Abu Dhabi Island</td>\n",
       "      <td>Abu Dhabi</td>\n",
       "      <td>AZ</td>\n",
       "      <td>AE</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>GMT+04:00 Asia/Dubai</td>\n",
       "      <td>54.54</td>\n",
       "      <td>24.51</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "       Brand  Store Number        Store Name Ownership Type  \\\n",
       "0  Starbucks  47370-257954     Meritxell, 96       Licensed   \n",
       "1  Starbucks  22331-212325  Ajman Drive Thru       Licensed   \n",
       "2  Starbucks  47089-256771         Dana Mall       Licensed   \n",
       "3  Starbucks  22126-218024        Twofour 54       Licensed   \n",
       "4  Starbucks  17127-178586      Al Ain Tower       Licensed   \n",
       "\n",
       "                    Street Address              City State/Province Country  \\\n",
       "0                Av. Meritxell, 96  Andorra la Vella              7      AD   \n",
       "1             1 Street 69, Al Jarf             Ajman             AJ      AE   \n",
       "2     Sheikh Khalifa Bin Zayed St.             Ajman             AJ      AE   \n",
       "3                  Al Salam Street         Abu Dhabi             AZ      AE   \n",
       "4  Khaldiya Area, Abu Dhabi Island         Abu Dhabi             AZ      AE   \n",
       "\n",
       "  Postcode Phone Number                 Timezone  Longitude  Latitude  \n",
       "0    AD500    376818720  GMT+1:00 Europe/Andorra       1.53     42.51  \n",
       "1      NaN          NaN     GMT+04:00 Asia/Dubai      55.47     25.42  \n",
       "2      NaN          NaN     GMT+04:00 Asia/Dubai      55.47     25.39  \n",
       "3      NaN          NaN     GMT+04:00 Asia/Dubai      54.38     24.48  \n",
       "4      NaN          NaN     GMT+04:00 Asia/Dubai      54.54     24.51  "
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data = pd.read_csv('directory.csv')\n",
    "data.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### 查看数据"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Longitude</th>\n",
       "      <th>Latitude</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>count</th>\n",
       "      <td>25599.000000</td>\n",
       "      <td>25599.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>mean</th>\n",
       "      <td>-27.872234</td>\n",
       "      <td>34.793016</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>std</th>\n",
       "      <td>96.844046</td>\n",
       "      <td>13.342332</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>min</th>\n",
       "      <td>-159.460000</td>\n",
       "      <td>-46.410000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25%</th>\n",
       "      <td>-104.665000</td>\n",
       "      <td>31.240000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50%</th>\n",
       "      <td>-79.350000</td>\n",
       "      <td>36.750000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75%</th>\n",
       "      <td>100.630000</td>\n",
       "      <td>41.570000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>max</th>\n",
       "      <td>176.920000</td>\n",
       "      <td>64.850000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "          Longitude      Latitude\n",
       "count  25599.000000  25599.000000\n",
       "mean     -27.872234     34.793016\n",
       "std       96.844046     13.342332\n",
       "min     -159.460000    -46.410000\n",
       "25%     -104.665000     31.240000\n",
       "50%      -79.350000     36.750000\n",
       "75%      100.630000     41.570000\n",
       "max      176.920000     64.850000"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.describe()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 25600 entries, 0 to 25599\n",
      "Data columns (total 13 columns):\n",
      "Brand             25600 non-null object\n",
      "Store Number      25600 non-null object\n",
      "Store Name        25600 non-null object\n",
      "Ownership Type    25600 non-null object\n",
      "Street Address    25598 non-null object\n",
      "City              25585 non-null object\n",
      "State/Province    25600 non-null object\n",
      "Country           25600 non-null object\n",
      "Postcode          24078 non-null object\n",
      "Phone Number      18739 non-null object\n",
      "Timezone          25600 non-null object\n",
      "Longitude         25599 non-null float64\n",
      "Latitude          25599 non-null float64\n",
      "dtypes: float64(2), object(11)\n",
      "memory usage: 2.5+ MB\n"
     ]
    }
   ],
   "source": [
    "data.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Brand                0\n",
       "Store Number         0\n",
       "Store Name           0\n",
       "Ownership Type       0\n",
       "Street Address       2\n",
       "City                15\n",
       "State/Province       0\n",
       "Country              0\n",
       "Postcode          1522\n",
       "Phone Number      6861\n",
       "Timezone             0\n",
       "Longitude            1\n",
       "Latitude             1\n",
       "dtype: int64"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.isnull().sum()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### 处理数据"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['Starbucks', 'Teavana', 'Evolution Fresh', 'Coffee House Holdings'], dtype=object)"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data['Brand'].unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "data = data[data['Brand'] == 'Starbucks']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['Starbucks'], dtype=object)"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data['Brand'].unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Brand                0\n",
       "Store Number         0\n",
       "Store Name           0\n",
       "Ownership Type       0\n",
       "Street Address       2\n",
       "City                15\n",
       "State/Province       0\n",
       "Country              0\n",
       "Postcode          1522\n",
       "Phone Number      6856\n",
       "Timezone             0\n",
       "Longitude            1\n",
       "Latitude             1\n",
       "dtype: int64"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.isnull().sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Brand</th>\n",
       "      <th>Store Number</th>\n",
       "      <th>Store Name</th>\n",
       "      <th>Ownership Type</th>\n",
       "      <th>Street Address</th>\n",
       "      <th>City</th>\n",
       "      <th>State/Province</th>\n",
       "      <th>Country</th>\n",
       "      <th>Postcode</th>\n",
       "      <th>Phone Number</th>\n",
       "      <th>Timezone</th>\n",
       "      <th>Longitude</th>\n",
       "      <th>Latitude</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>5069</th>\n",
       "      <td>Starbucks</td>\n",
       "      <td>31657-104436</td>\n",
       "      <td>سان ستيفانو</td>\n",
       "      <td>Licensed</td>\n",
       "      <td>طريق الكورنيش أبراج سان ستيفانو</td>\n",
       "      <td>NaN</td>\n",
       "      <td>ALX</td>\n",
       "      <td>EG</td>\n",
       "      <td>NaN</td>\n",
       "      <td>20120800287</td>\n",
       "      <td>GMT+2:00 Africa/Cairo</td>\n",
       "      <td>29.96</td>\n",
       "      <td>31.24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5088</th>\n",
       "      <td>Starbucks</td>\n",
       "      <td>32152-109504</td>\n",
       "      <td>النايل سيتى</td>\n",
       "      <td>Licensed</td>\n",
       "      <td>كورنيش النيل أبراج النايل سيتى</td>\n",
       "      <td>NaN</td>\n",
       "      <td>C</td>\n",
       "      <td>EG</td>\n",
       "      <td>NaN</td>\n",
       "      <td>20120800307</td>\n",
       "      <td>GMT+2:00 Africa/Cairo</td>\n",
       "      <td>31.23</td>\n",
       "      <td>30.07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5089</th>\n",
       "      <td>Starbucks</td>\n",
       "      <td>32314-115172</td>\n",
       "      <td>أسكندرية الصحراوى</td>\n",
       "      <td>Licensed</td>\n",
       "      <td>الكيلو 28 طريق الاسكندرية الصحراوى, سيتى سنتر ...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>C</td>\n",
       "      <td>EG</td>\n",
       "      <td>NaN</td>\n",
       "      <td>20185022214</td>\n",
       "      <td>GMT+2:00 Africa/Cairo</td>\n",
       "      <td>31.03</td>\n",
       "      <td>30.06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5090</th>\n",
       "      <td>Starbucks</td>\n",
       "      <td>31479-105246</td>\n",
       "      <td>مكرم عبيد</td>\n",
       "      <td>Licensed</td>\n",
       "      <td>شارع مكرم عبيد, سيتى ستارز مول</td>\n",
       "      <td>NaN</td>\n",
       "      <td>C</td>\n",
       "      <td>EG</td>\n",
       "      <td>NaN</td>\n",
       "      <td>20120800332</td>\n",
       "      <td>GMT+2:00 Africa/Cairo</td>\n",
       "      <td>31.34</td>\n",
       "      <td>30.09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5091</th>\n",
       "      <td>Starbucks</td>\n",
       "      <td>31756-107161</td>\n",
       "      <td>سيتى ستارز 1</td>\n",
       "      <td>Licensed</td>\n",
       "      <td>شارع عمر بن الخطاب, سيتى ستارز مول</td>\n",
       "      <td>NaN</td>\n",
       "      <td>C</td>\n",
       "      <td>EG</td>\n",
       "      <td>NaN</td>\n",
       "      <td>20120800350</td>\n",
       "      <td>GMT+2:00 Africa/Cairo</td>\n",
       "      <td>31.33</td>\n",
       "      <td>30.06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5092</th>\n",
       "      <td>Starbucks</td>\n",
       "      <td>1397-139244</td>\n",
       "      <td>سيتى ستارز 3</td>\n",
       "      <td>Licensed</td>\n",
       "      <td>شارع عمر بن الخطاب, كارفور المعادى</td>\n",
       "      <td>NaN</td>\n",
       "      <td>C</td>\n",
       "      <td>EG</td>\n",
       "      <td>NaN</td>\n",
       "      <td>20120029885</td>\n",
       "      <td>GMT+2:00 Africa/Cairo</td>\n",
       "      <td>31.33</td>\n",
       "      <td>30.06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5093</th>\n",
       "      <td>Starbucks</td>\n",
       "      <td>32191-116645</td>\n",
       "      <td>معادى سيتى سنتر</td>\n",
       "      <td>Licensed</td>\n",
       "      <td>القطامية الطريق الدائرى</td>\n",
       "      <td>NaN</td>\n",
       "      <td>C</td>\n",
       "      <td>EG</td>\n",
       "      <td>NaN</td>\n",
       "      <td>20185002677</td>\n",
       "      <td>GMT+2:00 Africa/Cairo</td>\n",
       "      <td>31.30</td>\n",
       "      <td>29.99</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5094</th>\n",
       "      <td>Starbucks</td>\n",
       "      <td>3664-142484</td>\n",
       "      <td>سليمان أباظة</td>\n",
       "      <td>Licensed</td>\n",
       "      <td>34شارع سليمان أباظة المهندسين, تيفولى مول</td>\n",
       "      <td>NaN</td>\n",
       "      <td>C</td>\n",
       "      <td>EG</td>\n",
       "      <td>NaN</td>\n",
       "      <td>129007799</td>\n",
       "      <td>GMT+2:00 Africa/Cairo</td>\n",
       "      <td>31.20</td>\n",
       "      <td>30.06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5095</th>\n",
       "      <td>Starbucks</td>\n",
       "      <td>3562-131562</td>\n",
       "      <td>تيفولى</td>\n",
       "      <td>Licensed</td>\n",
       "      <td>ألماظة ميدان الجوهر شارع أحمد فوزى, صالة السفر 1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>C</td>\n",
       "      <td>EG</td>\n",
       "      <td>NaN</td>\n",
       "      <td>018-0819995</td>\n",
       "      <td>GMT+2:00 Africa/Cairo</td>\n",
       "      <td>31.34</td>\n",
       "      <td>30.08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5096</th>\n",
       "      <td>Starbucks</td>\n",
       "      <td>31646-106547</td>\n",
       "      <td>مطار القاهرة</td>\n",
       "      <td>Licensed</td>\n",
       "      <td>صالة السفر 1- مطار القاهرة, فندق سنافير</td>\n",
       "      <td>NaN</td>\n",
       "      <td>C</td>\n",
       "      <td>EG</td>\n",
       "      <td>NaN</td>\n",
       "      <td>20120800335</td>\n",
       "      <td>GMT+2:00 Africa/Cairo</td>\n",
       "      <td>31.41</td>\n",
       "      <td>30.11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5097</th>\n",
       "      <td>Starbucks</td>\n",
       "      <td>31755-107182</td>\n",
       "      <td>سنافير - نعمه بيه</td>\n",
       "      <td>Licensed</td>\n",
       "      <td>فندق سنافير - نعمة بيه, المركاتو مول2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>JS</td>\n",
       "      <td>EG</td>\n",
       "      <td>NaN</td>\n",
       "      <td>20120800327</td>\n",
       "      <td>GMT+2:00 Africa/Cairo</td>\n",
       "      <td>34.33</td>\n",
       "      <td>27.91</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5098</th>\n",
       "      <td>Starbucks</td>\n",
       "      <td>32389-107342</td>\n",
       "      <td>المركاتو مول2</td>\n",
       "      <td>Licensed</td>\n",
       "      <td>الهضبة - الملركاتو2 بجوار المسرح الرومانى, مول...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>JS</td>\n",
       "      <td>EG</td>\n",
       "      <td>NaN</td>\n",
       "      <td>20185022217</td>\n",
       "      <td>GMT+2:00 Africa/Cairo</td>\n",
       "      <td>34.33</td>\n",
       "      <td>27.92</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5099</th>\n",
       "      <td>Starbucks</td>\n",
       "      <td>32490-111349</td>\n",
       "      <td>خان لاجونا</td>\n",
       "      <td>Licensed</td>\n",
       "      <td>خليج نبق مول - خان لاجونا</td>\n",
       "      <td>NaN</td>\n",
       "      <td>JS</td>\n",
       "      <td>EG</td>\n",
       "      <td>NaN</td>\n",
       "      <td>20189888547</td>\n",
       "      <td>GMT+2:00 Africa/Cairo</td>\n",
       "      <td>34.43</td>\n",
       "      <td>28.04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9871</th>\n",
       "      <td>Starbucks</td>\n",
       "      <td>26909-228505</td>\n",
       "      <td>Vivacity Megamall</td>\n",
       "      <td>Licensed</td>\n",
       "      <td>NA, Na</td>\n",
       "      <td>NaN</td>\n",
       "      <td>13</td>\n",
       "      <td>MY</td>\n",
       "      <td>NaN</td>\n",
       "      <td>82263673</td>\n",
       "      <td>GMT+08:00 Asia/Kuala_Lumpur</td>\n",
       "      <td>110.36</td>\n",
       "      <td>1.53</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10767</th>\n",
       "      <td>Starbucks</td>\n",
       "      <td>31429-102231</td>\n",
       "      <td>ابراج البيت 1</td>\n",
       "      <td>Licensed</td>\n",
       "      <td>شارع اجياد- باب الملك عبد العزيز</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>SA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>96625719012</td>\n",
       "      <td>GMT+03:00 Asia/Riyadh</td>\n",
       "      <td>39.83</td>\n",
       "      <td>21.42</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "           Brand  Store Number         Store Name Ownership Type  \\\n",
       "5069   Starbucks  31657-104436        سان ستيفانو       Licensed   \n",
       "5088   Starbucks  32152-109504        النايل سيتى       Licensed   \n",
       "5089   Starbucks  32314-115172  أسكندرية الصحراوى       Licensed   \n",
       "5090   Starbucks  31479-105246          مكرم عبيد       Licensed   \n",
       "5091   Starbucks  31756-107161       سيتى ستارز 1       Licensed   \n",
       "5092   Starbucks   1397-139244       سيتى ستارز 3       Licensed   \n",
       "5093   Starbucks  32191-116645    معادى سيتى سنتر       Licensed   \n",
       "5094   Starbucks   3664-142484       سليمان أباظة       Licensed   \n",
       "5095   Starbucks   3562-131562             تيفولى       Licensed   \n",
       "5096   Starbucks  31646-106547       مطار القاهرة       Licensed   \n",
       "5097   Starbucks  31755-107182  سنافير - نعمه بيه       Licensed   \n",
       "5098   Starbucks  32389-107342      المركاتو مول2       Licensed   \n",
       "5099   Starbucks  32490-111349         خان لاجونا       Licensed   \n",
       "9871   Starbucks  26909-228505  Vivacity Megamall       Licensed   \n",
       "10767  Starbucks  31429-102231      ابراج البيت 1       Licensed   \n",
       "\n",
       "                                          Street Address City State/Province  \\\n",
       "5069                     طريق الكورنيش أبراج سان ستيفانو  NaN            ALX   \n",
       "5088                      كورنيش النيل أبراج النايل سيتى  NaN              C   \n",
       "5089   الكيلو 28 طريق الاسكندرية الصحراوى, سيتى سنتر ...  NaN              C   \n",
       "5090                      شارع مكرم عبيد, سيتى ستارز مول  NaN              C   \n",
       "5091                  شارع عمر بن الخطاب, سيتى ستارز مول  NaN              C   \n",
       "5092                  شارع عمر بن الخطاب, كارفور المعادى  NaN              C   \n",
       "5093                             القطامية الطريق الدائرى  NaN              C   \n",
       "5094           34شارع سليمان أباظة المهندسين, تيفولى مول  NaN              C   \n",
       "5095    ألماظة ميدان الجوهر شارع أحمد فوزى, صالة السفر 1  NaN              C   \n",
       "5096             صالة السفر 1- مطار القاهرة, فندق سنافير  NaN              C   \n",
       "5097               فندق سنافير - نعمة بيه, المركاتو مول2  NaN             JS   \n",
       "5098   الهضبة - الملركاتو2 بجوار المسرح الرومانى, مول...  NaN             JS   \n",
       "5099                           خليج نبق مول - خان لاجونا  NaN             JS   \n",
       "9871                                              NA, Na  NaN             13   \n",
       "10767                   شارع اجياد- باب الملك عبد العزيز  NaN              2   \n",
       "\n",
       "      Country Postcode Phone Number                     Timezone  Longitude  \\\n",
       "5069       EG      NaN  20120800287        GMT+2:00 Africa/Cairo      29.96   \n",
       "5088       EG      NaN  20120800307        GMT+2:00 Africa/Cairo      31.23   \n",
       "5089       EG      NaN  20185022214        GMT+2:00 Africa/Cairo      31.03   \n",
       "5090       EG      NaN  20120800332        GMT+2:00 Africa/Cairo      31.34   \n",
       "5091       EG      NaN  20120800350        GMT+2:00 Africa/Cairo      31.33   \n",
       "5092       EG      NaN  20120029885        GMT+2:00 Africa/Cairo      31.33   \n",
       "5093       EG      NaN  20185002677        GMT+2:00 Africa/Cairo      31.30   \n",
       "5094       EG      NaN    129007799        GMT+2:00 Africa/Cairo      31.20   \n",
       "5095       EG      NaN  018-0819995        GMT+2:00 Africa/Cairo      31.34   \n",
       "5096       EG      NaN  20120800335        GMT+2:00 Africa/Cairo      31.41   \n",
       "5097       EG      NaN  20120800327        GMT+2:00 Africa/Cairo      34.33   \n",
       "5098       EG      NaN  20185022217        GMT+2:00 Africa/Cairo      34.33   \n",
       "5099       EG      NaN  20189888547        GMT+2:00 Africa/Cairo      34.43   \n",
       "9871       MY      NaN     82263673  GMT+08:00 Asia/Kuala_Lumpur     110.36   \n",
       "10767      SA      NaN  96625719012        GMT+03:00 Asia/Riyadh      39.83   \n",
       "\n",
       "       Latitude  \n",
       "5069      31.24  \n",
       "5088      30.07  \n",
       "5089      30.06  \n",
       "5090      30.09  \n",
       "5091      30.06  \n",
       "5092      30.06  \n",
       "5093      29.99  \n",
       "5094      30.06  \n",
       "5095      30.08  \n",
       "5096      30.11  \n",
       "5097      27.91  \n",
       "5098      27.92  \n",
       "5099      28.04  \n",
       "9871       1.53  \n",
       "10767     21.42  "
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data[data['City'].isnull()]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Brand</th>\n",
       "      <th>Store Number</th>\n",
       "      <th>Store Name</th>\n",
       "      <th>Ownership Type</th>\n",
       "      <th>Street Address</th>\n",
       "      <th>City</th>\n",
       "      <th>State/Province</th>\n",
       "      <th>Country</th>\n",
       "      <th>Postcode</th>\n",
       "      <th>Phone Number</th>\n",
       "      <th>Timezone</th>\n",
       "      <th>Longitude</th>\n",
       "      <th>Latitude</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>5069</th>\n",
       "      <td>Starbucks</td>\n",
       "      <td>31657-104436</td>\n",
       "      <td>سان ستيفانو</td>\n",
       "      <td>Licensed</td>\n",
       "      <td>طريق الكورنيش أبراج سان ستيفانو</td>\n",
       "      <td>ALX</td>\n",
       "      <td>ALX</td>\n",
       "      <td>EG</td>\n",
       "      <td>NaN</td>\n",
       "      <td>20120800287</td>\n",
       "      <td>GMT+2:00 Africa/Cairo</td>\n",
       "      <td>29.96</td>\n",
       "      <td>31.24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5070</th>\n",
       "      <td>Starbucks</td>\n",
       "      <td>15433-161464</td>\n",
       "      <td>Cityscape</td>\n",
       "      <td>Licensed</td>\n",
       "      <td>6 Of Octobe, El Horya Square, Giza</td>\n",
       "      <td>Cairo</td>\n",
       "      <td>C</td>\n",
       "      <td>EG</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>GMT+2:00 Africa/Cairo</td>\n",
       "      <td>31.35</td>\n",
       "      <td>30.13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5071</th>\n",
       "      <td>Starbucks</td>\n",
       "      <td>25827-242606</td>\n",
       "      <td>The Corner</td>\n",
       "      <td>Licensed</td>\n",
       "      <td>Zaker Hussein St. extension, Plot no. 4, Unit ...</td>\n",
       "      <td>Cairo</td>\n",
       "      <td>C</td>\n",
       "      <td>EG</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>GMT+2:00 Africa/Cairo</td>\n",
       "      <td>31.25</td>\n",
       "      <td>30.05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5072</th>\n",
       "      <td>Starbucks</td>\n",
       "      <td>26054-236446</td>\n",
       "      <td>The Hub</td>\n",
       "      <td>Licensed</td>\n",
       "      <td>Unit no :A1 Front of British School, 6 of oct/...</td>\n",
       "      <td>Cairo</td>\n",
       "      <td>C</td>\n",
       "      <td>EG</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>GMT+2:00 Africa/Cairo</td>\n",
       "      <td>31.27</td>\n",
       "      <td>30.01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5073</th>\n",
       "      <td>Starbucks</td>\n",
       "      <td>25473-241146</td>\n",
       "      <td>Drive Thru Emirates Gas Station 2</td>\n",
       "      <td>Licensed</td>\n",
       "      <td>Plot Number 11B06, Ring road, Cairo festival c...</td>\n",
       "      <td>Cairo</td>\n",
       "      <td>C</td>\n",
       "      <td>EG</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>GMT+2:00 Africa/Cairo</td>\n",
       "      <td>31.25</td>\n",
       "      <td>30.05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5074</th>\n",
       "      <td>Starbucks</td>\n",
       "      <td>29652-254745</td>\n",
       "      <td>City Stars Mall</td>\n",
       "      <td>Licensed</td>\n",
       "      <td>City stars Mall, Nasr city</td>\n",
       "      <td>Cairo</td>\n",
       "      <td>C</td>\n",
       "      <td>EG</td>\n",
       "      <td>EG-C</td>\n",
       "      <td>NaN</td>\n",
       "      <td>GMT+2:00 Africa/Cairo</td>\n",
       "      <td>31.20</td>\n",
       "      <td>30.02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5075</th>\n",
       "      <td>Starbucks</td>\n",
       "      <td>25472-241147</td>\n",
       "      <td>Point 90 Mall</td>\n",
       "      <td>Licensed</td>\n",
       "      <td>Plot no: 35 south investors zone, off 90 road,...</td>\n",
       "      <td>Cairo</td>\n",
       "      <td>C</td>\n",
       "      <td>EG</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>GMT+2:00 Africa/Cairo</td>\n",
       "      <td>31.24</td>\n",
       "      <td>30.04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5076</th>\n",
       "      <td>Starbucks</td>\n",
       "      <td>19742-200007</td>\n",
       "      <td>Cairo Festival City II</td>\n",
       "      <td>Licensed</td>\n",
       "      <td>Ring Rd and 90th, New Cairo District</td>\n",
       "      <td>Cairo</td>\n",
       "      <td>C</td>\n",
       "      <td>EG</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>GMT+2:00 Africa/Cairo</td>\n",
       "      <td>31.35</td>\n",
       "      <td>29.98</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5077</th>\n",
       "      <td>Starbucks</td>\n",
       "      <td>20111-200005</td>\n",
       "      <td>Gallaria 40 (Closed)</td>\n",
       "      <td>Licensed</td>\n",
       "      <td>26th of July Rd, Alsheikh Zayed, 6th of Octobe...</td>\n",
       "      <td>Cairo</td>\n",
       "      <td>C</td>\n",
       "      <td>EG</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>GMT+2:00 Africa/Cairo</td>\n",
       "      <td>31.25</td>\n",
       "      <td>30.05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5078</th>\n",
       "      <td>Starbucks</td>\n",
       "      <td>19539-202105</td>\n",
       "      <td>Tivoli Dome - Marina</td>\n",
       "      <td>Licensed</td>\n",
       "      <td>Marina - Gate 5, Marina District</td>\n",
       "      <td>Cairo</td>\n",
       "      <td>C</td>\n",
       "      <td>EG</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>GMT+2:00 Africa/Cairo</td>\n",
       "      <td>31.25</td>\n",
       "      <td>30.05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5079</th>\n",
       "      <td>Starbucks</td>\n",
       "      <td>25471-241148</td>\n",
       "      <td>Water way</td>\n",
       "      <td>Licensed</td>\n",
       "      <td>22 A first settlement ,North Investors, New Cairo</td>\n",
       "      <td>Cairo</td>\n",
       "      <td>C</td>\n",
       "      <td>EG</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>GMT+2:00 Africa/Cairo</td>\n",
       "      <td>31.25</td>\n",
       "      <td>30.05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5080</th>\n",
       "      <td>Starbucks</td>\n",
       "      <td>27462-247749</td>\n",
       "      <td>Gameit Eldowal</td>\n",
       "      <td>Licensed</td>\n",
       "      <td>Gamiet Eldowal Street, Mohandeseen</td>\n",
       "      <td>Cairo</td>\n",
       "      <td>C</td>\n",
       "      <td>EG</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>GMT+2:00 Africa/Cairo</td>\n",
       "      <td>31.24</td>\n",
       "      <td>30.04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5081</th>\n",
       "      <td>Starbucks</td>\n",
       "      <td>15432-161465</td>\n",
       "      <td>Dandy Mega Mall</td>\n",
       "      <td>Licensed</td>\n",
       "      <td>Alex Dandy Mega Mall, Alex desert Road - Kilo 28</td>\n",
       "      <td>Cairo</td>\n",
       "      <td>C</td>\n",
       "      <td>EG</td>\n",
       "      <td>NaN</td>\n",
       "      <td>02 01222887982</td>\n",
       "      <td>GMT+2:00 Africa/Cairo</td>\n",
       "      <td>29.75</td>\n",
       "      <td>31.08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5082</th>\n",
       "      <td>Starbucks</td>\n",
       "      <td>19743-200006</td>\n",
       "      <td>Cairo Festival City</td>\n",
       "      <td>Licensed</td>\n",
       "      <td>Ring rd and 90th, New Cairo</td>\n",
       "      <td>Cairo</td>\n",
       "      <td>C</td>\n",
       "      <td>EG</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>GMT+2:00 Africa/Cairo</td>\n",
       "      <td>31.35</td>\n",
       "      <td>29.98</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5083</th>\n",
       "      <td>Starbucks</td>\n",
       "      <td>25470-241149</td>\n",
       "      <td>Porto Cairo Mall</td>\n",
       "      <td>Licensed</td>\n",
       "      <td>The Ring Road, New Cairo, New Cairo, First set...</td>\n",
       "      <td>Cairo</td>\n",
       "      <td>C</td>\n",
       "      <td>EG</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>GMT+2:00 Africa/Cairo</td>\n",
       "      <td>31.33</td>\n",
       "      <td>29.98</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5084</th>\n",
       "      <td>Starbucks</td>\n",
       "      <td>15599-157707</td>\n",
       "      <td>Sun City Mall</td>\n",
       "      <td>Licensed</td>\n",
       "      <td>Sun City, Nasr St. Nasr City, Air Side, Arrivals</td>\n",
       "      <td>Cairo</td>\n",
       "      <td>C</td>\n",
       "      <td>EG</td>\n",
       "      <td>NaN</td>\n",
       "      <td>201201605271</td>\n",
       "      <td>GMT+2:00 Africa/Cairo</td>\n",
       "      <td>31.38</td>\n",
       "      <td>30.02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5085</th>\n",
       "      <td>Starbucks</td>\n",
       "      <td>16894-171864</td>\n",
       "      <td>Zayed Dome</td>\n",
       "      <td>Licensed</td>\n",
       "      <td>Zayed Dome complex-block no 8-part 3, District...</td>\n",
       "      <td>Cairo</td>\n",
       "      <td>C</td>\n",
       "      <td>EG</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>GMT+2:00 Africa/Cairo</td>\n",
       "      <td>31.21</td>\n",
       "      <td>30.01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5086</th>\n",
       "      <td>Starbucks</td>\n",
       "      <td>16565-172944</td>\n",
       "      <td>Katameya Downtown</td>\n",
       "      <td>Licensed</td>\n",
       "      <td>Street 90, New Cairo</td>\n",
       "      <td>Cairo</td>\n",
       "      <td>C</td>\n",
       "      <td>EG</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>GMT+2:00 Africa/Cairo</td>\n",
       "      <td>31.23</td>\n",
       "      <td>30.03</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5087</th>\n",
       "      <td>Starbucks</td>\n",
       "      <td>26786-245544</td>\n",
       "      <td>City Square - Cairo</td>\n",
       "      <td>Licensed</td>\n",
       "      <td>CITY Square Mall - Al Rehab City, New Cairo, أ...</td>\n",
       "      <td>Cairo</td>\n",
       "      <td>C</td>\n",
       "      <td>EG</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>GMT+2:00 Africa/Cairo</td>\n",
       "      <td>31.24</td>\n",
       "      <td>30.04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5088</th>\n",
       "      <td>Starbucks</td>\n",
       "      <td>32152-109504</td>\n",
       "      <td>النايل سيتى</td>\n",
       "      <td>Licensed</td>\n",
       "      <td>كورنيش النيل أبراج النايل سيتى</td>\n",
       "      <td>C</td>\n",
       "      <td>C</td>\n",
       "      <td>EG</td>\n",
       "      <td>NaN</td>\n",
       "      <td>20120800307</td>\n",
       "      <td>GMT+2:00 Africa/Cairo</td>\n",
       "      <td>31.23</td>\n",
       "      <td>30.07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5089</th>\n",
       "      <td>Starbucks</td>\n",
       "      <td>32314-115172</td>\n",
       "      <td>أسكندرية الصحراوى</td>\n",
       "      <td>Licensed</td>\n",
       "      <td>الكيلو 28 طريق الاسكندرية الصحراوى, سيتى سنتر ...</td>\n",
       "      <td>C</td>\n",
       "      <td>C</td>\n",
       "      <td>EG</td>\n",
       "      <td>NaN</td>\n",
       "      <td>20185022214</td>\n",
       "      <td>GMT+2:00 Africa/Cairo</td>\n",
       "      <td>31.03</td>\n",
       "      <td>30.06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5090</th>\n",
       "      <td>Starbucks</td>\n",
       "      <td>31479-105246</td>\n",
       "      <td>مكرم عبيد</td>\n",
       "      <td>Licensed</td>\n",
       "      <td>شارع مكرم عبيد, سيتى ستارز مول</td>\n",
       "      <td>C</td>\n",
       "      <td>C</td>\n",
       "      <td>EG</td>\n",
       "      <td>NaN</td>\n",
       "      <td>20120800332</td>\n",
       "      <td>GMT+2:00 Africa/Cairo</td>\n",
       "      <td>31.34</td>\n",
       "      <td>30.09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5091</th>\n",
       "      <td>Starbucks</td>\n",
       "      <td>31756-107161</td>\n",
       "      <td>سيتى ستارز 1</td>\n",
       "      <td>Licensed</td>\n",
       "      <td>شارع عمر بن الخطاب, سيتى ستارز مول</td>\n",
       "      <td>C</td>\n",
       "      <td>C</td>\n",
       "      <td>EG</td>\n",
       "      <td>NaN</td>\n",
       "      <td>20120800350</td>\n",
       "      <td>GMT+2:00 Africa/Cairo</td>\n",
       "      <td>31.33</td>\n",
       "      <td>30.06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5092</th>\n",
       "      <td>Starbucks</td>\n",
       "      <td>1397-139244</td>\n",
       "      <td>سيتى ستارز 3</td>\n",
       "      <td>Licensed</td>\n",
       "      <td>شارع عمر بن الخطاب, كارفور المعادى</td>\n",
       "      <td>C</td>\n",
       "      <td>C</td>\n",
       "      <td>EG</td>\n",
       "      <td>NaN</td>\n",
       "      <td>20120029885</td>\n",
       "      <td>GMT+2:00 Africa/Cairo</td>\n",
       "      <td>31.33</td>\n",
       "      <td>30.06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5093</th>\n",
       "      <td>Starbucks</td>\n",
       "      <td>32191-116645</td>\n",
       "      <td>معادى سيتى سنتر</td>\n",
       "      <td>Licensed</td>\n",
       "      <td>القطامية الطريق الدائرى</td>\n",
       "      <td>C</td>\n",
       "      <td>C</td>\n",
       "      <td>EG</td>\n",
       "      <td>NaN</td>\n",
       "      <td>20185002677</td>\n",
       "      <td>GMT+2:00 Africa/Cairo</td>\n",
       "      <td>31.30</td>\n",
       "      <td>29.99</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5094</th>\n",
       "      <td>Starbucks</td>\n",
       "      <td>3664-142484</td>\n",
       "      <td>سليمان أباظة</td>\n",
       "      <td>Licensed</td>\n",
       "      <td>34شارع سليمان أباظة المهندسين, تيفولى مول</td>\n",
       "      <td>C</td>\n",
       "      <td>C</td>\n",
       "      <td>EG</td>\n",
       "      <td>NaN</td>\n",
       "      <td>129007799</td>\n",
       "      <td>GMT+2:00 Africa/Cairo</td>\n",
       "      <td>31.20</td>\n",
       "      <td>30.06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5095</th>\n",
       "      <td>Starbucks</td>\n",
       "      <td>3562-131562</td>\n",
       "      <td>تيفولى</td>\n",
       "      <td>Licensed</td>\n",
       "      <td>ألماظة ميدان الجوهر شارع أحمد فوزى, صالة السفر 1</td>\n",
       "      <td>C</td>\n",
       "      <td>C</td>\n",
       "      <td>EG</td>\n",
       "      <td>NaN</td>\n",
       "      <td>018-0819995</td>\n",
       "      <td>GMT+2:00 Africa/Cairo</td>\n",
       "      <td>31.34</td>\n",
       "      <td>30.08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5096</th>\n",
       "      <td>Starbucks</td>\n",
       "      <td>31646-106547</td>\n",
       "      <td>مطار القاهرة</td>\n",
       "      <td>Licensed</td>\n",
       "      <td>صالة السفر 1- مطار القاهرة, فندق سنافير</td>\n",
       "      <td>C</td>\n",
       "      <td>C</td>\n",
       "      <td>EG</td>\n",
       "      <td>NaN</td>\n",
       "      <td>20120800335</td>\n",
       "      <td>GMT+2:00 Africa/Cairo</td>\n",
       "      <td>31.41</td>\n",
       "      <td>30.11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5097</th>\n",
       "      <td>Starbucks</td>\n",
       "      <td>31755-107182</td>\n",
       "      <td>سنافير - نعمه بيه</td>\n",
       "      <td>Licensed</td>\n",
       "      <td>فندق سنافير - نعمة بيه, المركاتو مول2</td>\n",
       "      <td>JS</td>\n",
       "      <td>JS</td>\n",
       "      <td>EG</td>\n",
       "      <td>NaN</td>\n",
       "      <td>20120800327</td>\n",
       "      <td>GMT+2:00 Africa/Cairo</td>\n",
       "      <td>34.33</td>\n",
       "      <td>27.91</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5098</th>\n",
       "      <td>Starbucks</td>\n",
       "      <td>32389-107342</td>\n",
       "      <td>المركاتو مول2</td>\n",
       "      <td>Licensed</td>\n",
       "      <td>الهضبة - الملركاتو2 بجوار المسرح الرومانى, مول...</td>\n",
       "      <td>JS</td>\n",
       "      <td>JS</td>\n",
       "      <td>EG</td>\n",
       "      <td>NaN</td>\n",
       "      <td>20185022217</td>\n",
       "      <td>GMT+2:00 Africa/Cairo</td>\n",
       "      <td>34.33</td>\n",
       "      <td>27.92</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5099</th>\n",
       "      <td>Starbucks</td>\n",
       "      <td>32490-111349</td>\n",
       "      <td>خان لاجونا</td>\n",
       "      <td>Licensed</td>\n",
       "      <td>خليج نبق مول - خان لاجونا</td>\n",
       "      <td>JS</td>\n",
       "      <td>JS</td>\n",
       "      <td>EG</td>\n",
       "      <td>NaN</td>\n",
       "      <td>20189888547</td>\n",
       "      <td>GMT+2:00 Africa/Cairo</td>\n",
       "      <td>34.43</td>\n",
       "      <td>28.04</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "          Brand  Store Number                         Store Name  \\\n",
       "5069  Starbucks  31657-104436                        سان ستيفانو   \n",
       "5070  Starbucks  15433-161464                          Cityscape   \n",
       "5071  Starbucks  25827-242606                         The Corner   \n",
       "5072  Starbucks  26054-236446                            The Hub   \n",
       "5073  Starbucks  25473-241146  Drive Thru Emirates Gas Station 2   \n",
       "5074  Starbucks  29652-254745                    City Stars Mall   \n",
       "5075  Starbucks  25472-241147                      Point 90 Mall   \n",
       "5076  Starbucks  19742-200007             Cairo Festival City II   \n",
       "5077  Starbucks  20111-200005               Gallaria 40 (Closed)   \n",
       "5078  Starbucks  19539-202105               Tivoli Dome - Marina   \n",
       "5079  Starbucks  25471-241148                          Water way   \n",
       "5080  Starbucks  27462-247749                     Gameit Eldowal   \n",
       "5081  Starbucks  15432-161465                    Dandy Mega Mall   \n",
       "5082  Starbucks  19743-200006                Cairo Festival City   \n",
       "5083  Starbucks  25470-241149                   Porto Cairo Mall   \n",
       "5084  Starbucks  15599-157707                      Sun City Mall   \n",
       "5085  Starbucks  16894-171864                         Zayed Dome   \n",
       "5086  Starbucks  16565-172944                  Katameya Downtown   \n",
       "5087  Starbucks  26786-245544                City Square - Cairo   \n",
       "5088  Starbucks  32152-109504                        النايل سيتى   \n",
       "5089  Starbucks  32314-115172                  أسكندرية الصحراوى   \n",
       "5090  Starbucks  31479-105246                          مكرم عبيد   \n",
       "5091  Starbucks  31756-107161                       سيتى ستارز 1   \n",
       "5092  Starbucks   1397-139244                       سيتى ستارز 3   \n",
       "5093  Starbucks  32191-116645                    معادى سيتى سنتر   \n",
       "5094  Starbucks   3664-142484                       سليمان أباظة   \n",
       "5095  Starbucks   3562-131562                             تيفولى   \n",
       "5096  Starbucks  31646-106547                       مطار القاهرة   \n",
       "5097  Starbucks  31755-107182                  سنافير - نعمه بيه   \n",
       "5098  Starbucks  32389-107342                      المركاتو مول2   \n",
       "5099  Starbucks  32490-111349                         خان لاجونا   \n",
       "\n",
       "     Ownership Type                                     Street Address   City  \\\n",
       "5069       Licensed                    طريق الكورنيش أبراج سان ستيفانو    ALX   \n",
       "5070       Licensed                 6 Of Octobe, El Horya Square, Giza  Cairo   \n",
       "5071       Licensed  Zaker Hussein St. extension, Plot no. 4, Unit ...  Cairo   \n",
       "5072       Licensed  Unit no :A1 Front of British School, 6 of oct/...  Cairo   \n",
       "5073       Licensed  Plot Number 11B06, Ring road, Cairo festival c...  Cairo   \n",
       "5074       Licensed                         City stars Mall, Nasr city  Cairo   \n",
       "5075       Licensed  Plot no: 35 south investors zone, off 90 road,...  Cairo   \n",
       "5076       Licensed               Ring Rd and 90th, New Cairo District  Cairo   \n",
       "5077       Licensed  26th of July Rd, Alsheikh Zayed, 6th of Octobe...  Cairo   \n",
       "5078       Licensed                   Marina - Gate 5, Marina District  Cairo   \n",
       "5079       Licensed  22 A first settlement ,North Investors, New Cairo  Cairo   \n",
       "5080       Licensed                 Gamiet Eldowal Street, Mohandeseen  Cairo   \n",
       "5081       Licensed   Alex Dandy Mega Mall, Alex desert Road - Kilo 28  Cairo   \n",
       "5082       Licensed                        Ring rd and 90th, New Cairo  Cairo   \n",
       "5083       Licensed  The Ring Road, New Cairo, New Cairo, First set...  Cairo   \n",
       "5084       Licensed   Sun City, Nasr St. Nasr City, Air Side, Arrivals  Cairo   \n",
       "5085       Licensed  Zayed Dome complex-block no 8-part 3, District...  Cairo   \n",
       "5086       Licensed                               Street 90, New Cairo  Cairo   \n",
       "5087       Licensed  CITY Square Mall - Al Rehab City, New Cairo, أ...  Cairo   \n",
       "5088       Licensed                     كورنيش النيل أبراج النايل سيتى      C   \n",
       "5089       Licensed  الكيلو 28 طريق الاسكندرية الصحراوى, سيتى سنتر ...      C   \n",
       "5090       Licensed                     شارع مكرم عبيد, سيتى ستارز مول      C   \n",
       "5091       Licensed                 شارع عمر بن الخطاب, سيتى ستارز مول      C   \n",
       "5092       Licensed                 شارع عمر بن الخطاب, كارفور المعادى      C   \n",
       "5093       Licensed                            القطامية الطريق الدائرى      C   \n",
       "5094       Licensed          34شارع سليمان أباظة المهندسين, تيفولى مول      C   \n",
       "5095       Licensed   ألماظة ميدان الجوهر شارع أحمد فوزى, صالة السفر 1      C   \n",
       "5096       Licensed            صالة السفر 1- مطار القاهرة, فندق سنافير      C   \n",
       "5097       Licensed              فندق سنافير - نعمة بيه, المركاتو مول2     JS   \n",
       "5098       Licensed  الهضبة - الملركاتو2 بجوار المسرح الرومانى, مول...     JS   \n",
       "5099       Licensed                          خليج نبق مول - خان لاجونا     JS   \n",
       "\n",
       "     State/Province Country Postcode    Phone Number               Timezone  \\\n",
       "5069            ALX      EG      NaN     20120800287  GMT+2:00 Africa/Cairo   \n",
       "5070              C      EG      NaN             NaN  GMT+2:00 Africa/Cairo   \n",
       "5071              C      EG      NaN             NaN  GMT+2:00 Africa/Cairo   \n",
       "5072              C      EG      NaN             NaN  GMT+2:00 Africa/Cairo   \n",
       "5073              C      EG      NaN             NaN  GMT+2:00 Africa/Cairo   \n",
       "5074              C      EG     EG-C             NaN  GMT+2:00 Africa/Cairo   \n",
       "5075              C      EG      NaN             NaN  GMT+2:00 Africa/Cairo   \n",
       "5076              C      EG      NaN             NaN  GMT+2:00 Africa/Cairo   \n",
       "5077              C      EG      NaN             NaN  GMT+2:00 Africa/Cairo   \n",
       "5078              C      EG      NaN             NaN  GMT+2:00 Africa/Cairo   \n",
       "5079              C      EG      NaN             NaN  GMT+2:00 Africa/Cairo   \n",
       "5080              C      EG      NaN             NaN  GMT+2:00 Africa/Cairo   \n",
       "5081              C      EG      NaN  02 01222887982  GMT+2:00 Africa/Cairo   \n",
       "5082              C      EG      NaN             NaN  GMT+2:00 Africa/Cairo   \n",
       "5083              C      EG      NaN             NaN  GMT+2:00 Africa/Cairo   \n",
       "5084              C      EG      NaN    201201605271  GMT+2:00 Africa/Cairo   \n",
       "5085              C      EG      NaN             NaN  GMT+2:00 Africa/Cairo   \n",
       "5086              C      EG      NaN             NaN  GMT+2:00 Africa/Cairo   \n",
       "5087              C      EG      NaN             NaN  GMT+2:00 Africa/Cairo   \n",
       "5088              C      EG      NaN     20120800307  GMT+2:00 Africa/Cairo   \n",
       "5089              C      EG      NaN     20185022214  GMT+2:00 Africa/Cairo   \n",
       "5090              C      EG      NaN     20120800332  GMT+2:00 Africa/Cairo   \n",
       "5091              C      EG      NaN     20120800350  GMT+2:00 Africa/Cairo   \n",
       "5092              C      EG      NaN     20120029885  GMT+2:00 Africa/Cairo   \n",
       "5093              C      EG      NaN     20185002677  GMT+2:00 Africa/Cairo   \n",
       "5094              C      EG      NaN       129007799  GMT+2:00 Africa/Cairo   \n",
       "5095              C      EG      NaN     018-0819995  GMT+2:00 Africa/Cairo   \n",
       "5096              C      EG      NaN     20120800335  GMT+2:00 Africa/Cairo   \n",
       "5097             JS      EG      NaN     20120800327  GMT+2:00 Africa/Cairo   \n",
       "5098             JS      EG      NaN     20185022217  GMT+2:00 Africa/Cairo   \n",
       "5099             JS      EG      NaN     20189888547  GMT+2:00 Africa/Cairo   \n",
       "\n",
       "      Longitude  Latitude  \n",
       "5069      29.96     31.24  \n",
       "5070      31.35     30.13  \n",
       "5071      31.25     30.05  \n",
       "5072      31.27     30.01  \n",
       "5073      31.25     30.05  \n",
       "5074      31.20     30.02  \n",
       "5075      31.24     30.04  \n",
       "5076      31.35     29.98  \n",
       "5077      31.25     30.05  \n",
       "5078      31.25     30.05  \n",
       "5079      31.25     30.05  \n",
       "5080      31.24     30.04  \n",
       "5081      29.75     31.08  \n",
       "5082      31.35     29.98  \n",
       "5083      31.33     29.98  \n",
       "5084      31.38     30.02  \n",
       "5085      31.21     30.01  \n",
       "5086      31.23     30.03  \n",
       "5087      31.24     30.04  \n",
       "5088      31.23     30.07  \n",
       "5089      31.03     30.06  \n",
       "5090      31.34     30.09  \n",
       "5091      31.33     30.06  \n",
       "5092      31.33     30.06  \n",
       "5093      31.30     29.99  \n",
       "5094      31.20     30.06  \n",
       "5095      31.34     30.08  \n",
       "5096      31.41     30.11  \n",
       "5097      34.33     27.91  \n",
       "5098      34.33     27.92  \n",
       "5099      34.43     28.04  "
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "def fill_na(x):\n",
    "    return x\n",
    "\n",
    "data['City'] = data['City'].fillna(fill_na(data['State/Province']))\n",
    "data[data['Country']=='EG']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "E:\\Anaconda3\\lib\\site-packages\\ipykernel_launcher.py:1: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: http://pandas.pydata.org/pandas-docs/stable/indexing.html#indexing-view-versus-copy\n",
      "  \"\"\"Entry point for launching an IPython kernel.\n"
     ]
    }
   ],
   "source": [
    "data['Country'][data['Country'] == 'TW'] = 'CN'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Brand</th>\n",
       "      <th>Store Number</th>\n",
       "      <th>Store Name</th>\n",
       "      <th>Ownership Type</th>\n",
       "      <th>Street Address</th>\n",
       "      <th>City</th>\n",
       "      <th>State/Province</th>\n",
       "      <th>Country</th>\n",
       "      <th>Postcode</th>\n",
       "      <th>Phone Number</th>\n",
       "      <th>Timezone</th>\n",
       "      <th>Longitude</th>\n",
       "      <th>Latitude</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "Empty DataFrame\n",
       "Columns: [Brand, Store Number, Store Name, Ownership Type, Street Address, City, State/Province, Country, Postcode, Phone Number, Timezone, Longitude, Latitude]\n",
       "Index: []"
      ]
     },
     "execution_count": 25,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data[data['Country'] == 'TW']"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### 数据分析+可视化"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "US    13311\n",
       "CN     3128\n",
       "CA     1415\n",
       "JP     1237\n",
       "KR      993\n",
       "GB      901\n",
       "MX      579\n",
       "TR      326\n",
       "PH      298\n",
       "TH      289\n",
       "Name: Country, dtype: int64"
      ]
     },
     "execution_count": 26,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "country_count = data['Country'].value_counts()[0:10]\n",
    "country_count"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<matplotlib.axes._subplots.AxesSubplot at 0x23198af9710>"
      ]
     },
     "execution_count": 33,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAYAAAAD8CAYAAAB+UHOxAAAABHNCSVQICAgIfAhkiAAAAAlwSFlz\nAAALEgAACxIB0t1+/AAAADl0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uIDIuMS4wLCBo\ndHRwOi8vbWF0cGxvdGxpYi5vcmcvpW3flQAAEVdJREFUeJzt3X+QXWV9x/H3t/mBcUNttNtIOgqm\nRoVqg7hVAgluJIjI2I4UDVa0bVqDjtU6nVbjQKVarLTT0YojTreDaVp/1OhUJQNWqCQmxICzq9VR\nUWk1qYahXQwkRmfUpt/+cU7Mmizk3LvLOZc879dMhud+z91zvnd3537u8zz3LpGZSJLK83NdNyBJ\n6oYBIEmFMgAkqVAGgCQVygCQpEIZAJJUKANAkgrVKAAiYnFE7Diq9vSIuLUez4uILRGxMyLW9VKT\nJHXjuAEQEYuATcDQlFoA7wTm1aXXAROZeS5waUSc3ENNktSBuQ3ucwhYC3xySu33gK3AhfXtUWBD\nPd4OjPRQ2zr1YhGxHlgPMDQ09KynPe1pDR+KJAlgYmLivswcPt79jhsAmXkAoHrRDxHxOOByqif/\nwwEwBOytx/uAxT3Ujr7eGDAGMDIykuPj48drUZI0RUTsaXK/fjaBrwXenJk/mVI7CCyoxwvr8zat\nSZI60M8T8HOBv4qIbcCZEXENMAGsrI8vB3b3UJMkdaDJHsDPyMynHB5HxLbMvCoiTgVujohVwBnA\nnVRLPU1qkqQONJ4BZObog9Uycw9wAbATWJOZh5rWZvwIJEl96XkG8GAy8x5gcz81SVL73ISVpEIZ\nAJJUKANAkgplAEhSoWZtE7gLp224acbn2H3txbPQiSQ98jgDkKRCGQCSVCgDQJIKZQBIUqEMAEkq\nlAEgSYUyACSpUAaAJBXKAJCkQhkAklQoA0CSCmUASFKhDABJKpQBIEmFMgAkqVAGgCQVygCQpEI1\nCoCIWBwRO+rxEyNiW0TcFhFjUZkXEVsiYmdErKvv16gmSerGcQMgIhYBm4ChunQF8JrMfB7wBOAZ\nwOuAicw8F7g0Ik7uoSZJ6kCTGcAhYC1wACAzr8zMu+pjjwPuA0aBzXVtOzDSQ+1nRMT6iBiPiPHJ\nycneHo0kqbHjBkBmHsjM/UfXI2It8NXMvIdqdrC3PrQPWNxD7ejrjWXmSGaODA8P9/hwJElN9bUJ\nHBFLgT8B3lCXDgIL6vHC+rxNa5KkDvT8BFzvCXwYWDdlZjABrKzHy4HdPdQkSR2Y28fXbACeCLwn\nIgCuptokvjkiVgFnAHdSLfU0qUmSOtB4BpCZo/V/35SZp2TmaP3vs5m5B7gA2AmsycxDTWuz/YAk\nSc30MwOYVr0ZvLmfmiSpfW7CSlKhDABJKpQBIEmFMgAkqVAGgCQVygCQpEIZAJJUKANAkgplAEhS\noQwASSqUASBJhTIAJKlQBoAkFcoAkKRCGQCSVCgDQJIKZQBIUqEMAEkqlAEgSYUyACSpUAaAJBXK\nAJCkQjUKgIhYHBE76vG8iNgSETsjYt1Ma5Kkbhw3ACJiEbAJGKpLrwMmMvNc4NKIOHmGNUlSB5rM\nAA4Ba4ED9e1RYHM93g6MzLD2MyJifUSMR8T45ORk4wciSerNcQMgMw9k5v4ppSFgbz3eByyeYe3o\n641l5khmjgwPD/f2aCRJjfWzCXwQWFCPF9bnmElNktSBfp6AJ4CV9Xg5sHuGNUlSB+b28TWbgJsj\nYhVwBnAn1bJOvzVJUgcazwAyc7T+7x7gAmAnsCYzD82kNquPRpLUWD8zADLzHo68m2fGNUlS+9yE\nlaRCGQCSVCgDQJIKZQBIUqEMAEkqlAEgSYUyACSpUAaAJBXKAJCkQhkAklQoA0CSCmUASFKhDABJ\nKpQBIEmFMgAkqVAGgCQVygCQpEIZAJJUKANAkgplAEhSoQwASSqUASBJheo5ACJiUUTcHBHjEfF3\nde2GiNgVEVdNuV+jmiSpG/3MAF4BfDAzR4CTI+KNwJzMXAEsjYhlEXFJk9qsPQpJUs/6CYDvAU+P\niF8AngA8CdhcH7sFWAmMNqwdIyLW17OL8cnJyT7akyQ10U8A3A6cCrweuAuYD+ytj+0DFgNDDWvH\nyMyxzBzJzJHh4eE+2pMkNdFPAFwNvDoz3wZ8HfhtYEF9bGF9zoMNa5KkjvTzJLwIeEZEzAGeA1zL\nkeWc5cBuYKJhTZLUkbl9fM07gI1Uy0C7gHcBOyJiCXARcDaQDWuSpI70PAPIzM9n5q9m5sLMvCAz\nD1Bt8N4BrM7M/U1rs/UgJEm962cGcIzMvJ8j7/DpqSZJ6oYbsZJUKANAkgplAEhSoQwASSqUASBJ\nhTIAJKlQBoAkFcoAkKRCGQCSVCgDQJIKZQBIUqEMAEkqlAEgSYUyACSpUAaAJBXKAJCkQhkAklQo\nA0CSCmUASFKhDABJKpQBIEmFMgAkqVB9B0BEXB8RL6rHN0TEroi4asrxRjVJUjf6CoCIWAU8PjO3\nRMQlwJzMXAEsjYhlTWuz9igkST3rOQAiYh7w98DuiPhNYBTYXB++BVjZQ22686+PiPGIGJ+cnOy1\nPUlSQ/3MAF4JfA34a+DZwGuBvfWxfcBiYKhh7RiZOZaZI5k5Mjw83Ed7kqQm5vbxNc8ExjLz3oj4\nAHAOsKA+tpAqVA42rEmSOtLPk/B/AEvr8QhwGkeWc5YDu4GJhjVJUkf6mQHcALw/Ii4D5lGt7d8Y\nEUuAi4CzgQR2NKhJkjrS8wwgM7+fmS/JzPMyc0Vm7qEKgTuA1Zm5PzMPNKnN1oOQJPWunxnAMTLz\nfo68w6enmiSpG27ESlKhDABJKpQBIEmFMgAkqVAGgCQVygCQpEIZAJJUKANAkgplAEhSoQwASSqU\nASBJhTIAJKlQBoAkFcoAkKRCGQCSVCgDQJIKZQBIUqEMAEkqlAEgSYUyACSpUAaAJBXKAJCkQvUd\nABGxOCK+WI9viIhdEXHVlOONapKkbsxkBvA3wIKIuASYk5krgKURsaxpbebtS5L61VcARMTzgB8A\n9wKjwOb60C3Ayh5qkqSO9BwAETEf+DNgQ10aAvbW433A4h5q051/fUSMR8T45ORkr+1JkhrqZwaw\nAbg+Mx+obx8EFtTjhfU5m9aOkZljmTmSmSPDw8N9tCdJaqKfAFgDvDYitgFnAi/iyHLOcmA3MNGw\nJknqyNxevyAzzzs8rkPgN4AdEbEEuAg4G8iGNUlSR2b0OYDMHM3MA1QbvHcAqzNzf9PaTK4tSZqZ\nnmcA08nM+znyDp+eapKkbvhJYEkqlAEgSYUyACSpUAaAJBXKAJCkQhkAklQoA0CSCjUrnwMo3Wkb\nbprxOXZfe/EsdCJJzTkDkKRCGQCSVCgDQJIKZQBIUqEMAEkqlAEgSYUyACSpUAaAJBXKAJCkQhkA\nklQoA0CSCmUASFKhDABJKpQBIEmF6jkAIuIxEfGpiLglIj4eEfMj4oaI2BURV025X6OaJKkb/cwA\nXg68MzOfD9wLXAbMycwVwNKIWBYRlzSpzdaDkCT1ruf/IUxmXj/l5jBwOfC39e1bgJXAM4HNDWp3\n996yJGk29L0HEBErgEXAd4C9dXkfsBgYalib7rzrI2I8IsYnJyf7bU+SdBx9BUBEPBZ4D7AOOAgs\nqA8trM/ZtHaMzBzLzJHMHBkeHu6nPUlSA/1sAs8HPgq8OTP3ABNUyzkAy4HdPdQkSR3p538K//vA\nWcCVEXElsBF4RUQsAS4CzgYS2NGgJknqSM8zgMx8X2YuyszR+t8mYBS4A1idmfsz80CT2mw9CElS\n7/qZARwjM+/nyDt8eqpJkrrhJ4ElqVAGgCQVygCQpELNyh6AunfahptmfI7d1148C51IeqRwBiBJ\nhTIAJKlQLgFpVrkUJT1yOAOQpEIZAJJUKJeAdMJxGUpqxhmAJBXKGYD0MHEmokHnDECSCmUASFKh\nDABJKpQBIEmFchNYOoG5Ea2H4gxAkgplAEhSoQwASSqUewCSHnaDsBcxCD0MUh/gDECSimUASFKh\nWg+AiLghInZFxFVtX1uSdESrARARlwBzMnMFsDQilrV5fUnSEZGZ7V0s4jrgXzPz5oi4DFiQmRuP\nus96YH1986nAN2Z42V8E7pvhOWZqEHqAwehjEHqAwehjEHqAwehjEHqAwehjNno4NTOHj3entt8F\nNATsrcf7gLOOvkNmjgFjs3XBiBjPzJHZOt8jtYdB6WMQehiUPgahh0HpYxB6GJQ+2uyh7T2Ag8CC\nerywg+tLkmptPwFPACvr8XJgd8vXlyTV2l4C+gSwIyKWABcBZ7dwzVlbTpqBQegBBqOPQegBBqOP\nQegBBqOPQegBBqOP1npodRMYICIWARcA2zPz3lYvLkn6qdYDQJI0GNyElaRCGQCSVKgT7q+BRsQv\nZeb/1ONVwKMy89aO21LHIuKpwI8z89tTaiOZOd5hW8WKiDnAGqqfyda6FsBvZebHWurhlQ92LDP/\nsY0euu7jhAqAiHgH1dtLXxgRG4AXAN+MiJdl5roW+3jLgx3LzLe11cdUEfHLVN+PCzPzpS1e9/HA\n64EfAu/OzO+3de0pPbwbeAZwUkR8HLgb+GOqDyO+uMU+Ang+8ANgF7ABOBl4b2Z+p6UezsvM7UfV\nTgKuyMzr2uih9iGq78PCiHgx8J/AHwCfAVoJAOAJU8brgPe3dN2B6eOE2gSOiNszc2VEnAJsA34t\nM38UEVszc3WLfVw95WYCq4HnAtsy83kt9TAfOI/qSX8NcCpwHbA1M7e10UPdx63APwCLgOdk5iva\nuvaUHj6fmc+OiLnAd4F/Ad6VmXe33MeHgQeoPup/CjAO3A+sycxVLfXwEeBxwF8AdwKvAX4H+Ehm\nvqONHuo+PpeZ59Sh+G3gemAsMx9oq4ej+mn1OWJQ+jihZgDAwYi4FLgceCdwqF4Gmt9mE5n51voJ\n+HLgCuDrwFmZ+e8ttnEfcBLwXuB84GOZefVDf8nDYn5mfhCg/tl04Sf1i4IAvgVcU/ezJDPvabGP\nx2fmy+pr35WZb6jHF7TVQGaujYjTgZuAYeBGqmD+UVs91B4VESuofib7gNuBMyKCzPxcGw1ExDlT\nbv781Ntt9dB1HyfaDOBy4C3AJqpPGf8K8Frg/Mz8Sot9vJ1qOvsVqifgn37eocVf7sOft3gBsILq\nVd9fArdl5pfb6KHu42tUrzYDuBJ4++Fjmfmhlnq4D/hy3QNUs7J5wJMz85Q2eqj7+ALV72MA7wH+\n8PA4M5/VUg9vo/oQ5hhwG/CnwOlUM6JPtNFD3ccDVDOxOOpQtrVcGxGfBr4HvBT4JHCg7R7qPjr7\nXpxoATDdK9ylwEmZeVmLfXyUaq33J8AW4CVUa+BbM3NtSz08muqvqt6dmTfV+xL/B6zOzPPb6KHu\n426qJ1yofsH/F/gvYGdb+yER8UXguszcWC85vJwqjLZn5hVt9FD38UHgUqrlybOAxxw+lpmtzFIj\n4rvAVqrfTah+Jk8EfpSZL2yjh7qP29paDn2IHv4N2Ag8Fnh2F8uTdR+dLT+dUEtAmfnW6eoR8dmW\nW5kDvAn4dGZ+OyLeR7UHcG6LPfwTcCvw1fr2p+oe2t6E/cA0tSfV/9qyErg+Ii4Gngx8Cbg4M7/V\nYg8AjwKupXr1vwX4c+BMqj2attwOPIsqAL5E9fe53g/sabEHgLMj4ptH1YLqVe9TWuph7pTlyW0t\nXXM6z+nqe3GizQDOmaa8FHh1Zq6c5tjD1cfOzDzmyf7wJnUpPTyUNl/11L8XAfwuMEq1DHMQWl/r\n3Z6Z59XjyzPzA/V42p/Vw9zLY4G1VN+TXwe+kZmnt3j9zjdd6+XJaziyPHnN4WNtLU/WfTgDmCWv\nOup2Av9NNeVv020RcRtwM9UG10Kq9fgvtNjDZwagh2NExHlUM6EftnjZV1H9LgTVK+CX1fUEWgsA\n4IsR8QmqJaADEfFHwIVUr8RbERH/TPVW6R/X1/0w8Eba/8u8bb3V86F8BFg2zbjtV8WdfS9OqBnA\nIKnf4XAhsJhqc2lnZt5YWg/T9LQWeDTV2w7bDIGBEBHnU81ChoH9tPwziYiND3Ko1Y1PDQYDQJIK\n5d8CkqRCGQCSVCgDQJIKZQBIUqH+H2KAXndSt7eDAAAAAElFTkSuQmCC\n",
      "text/plain": [
       "<matplotlib.figure.Figure at 0x23197521dd8>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "import matplotlib.pyplot as plt\n",
    "plt.rcParams['font.sans-serif'] = ['simhei'] #指定默认字体\n",
    "plt.rcParams['axes.unicode_minus'] = False   #解决保存图像是负号'-'显示为方块的问题\n",
    "%matplotlib inline\n",
    "\n",
    "country_count.plot(kind='bar')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 34,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "上海市            542\n",
       "Seoul          243\n",
       "北京市            234\n",
       "New York       230\n",
       "London         215\n",
       "Toronto        186\n",
       "Mexico City    180\n",
       "Chicago        179\n",
       "Las Vegas      153\n",
       "Seattle        151\n",
       "Name: City, dtype: int64"
      ]
     },
     "execution_count": 34,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "city_count = data['City'].value_counts()[0:10]\n",
    "city_count"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<matplotlib.axes._subplots.AxesSubplot at 0x23198605390>"
      ]
     },
     "execution_count": 35,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAZ4AAAD6CAYAAACRbiH3AAAABHNCSVQICAgIfAhkiAAAAAlwSFlz\nAAALEgAACxIB0t1+/AAAADl0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uIDIuMS4wLCBo\ndHRwOi8vbWF0cGxvdGxpYi5vcmcvpW3flQAAGK9JREFUeJzt3X+UX3V95/Hny0hiIhJRKMZ018gx\nVUAwqyMnKpLID4GjdcW2KlYqYoh6tC311DZ4cJfWXWV3PS4WURuiRCniUQR/EOWHlRBFQCeiJnRF\nXORXLLX+CgqsaHzvH/dGh+E7mZlk5n6/mTwf5+R87/3M537u58OEvOZz7537SVUhSVJXHtHvDkiS\n9iwGjySpUwaPJKlTBo8kqVMGjySpUwaPJKlTBo8kqVMGjySpUwaPJKlTj+x3BwbRfvvtV4sWLep3\nNyRpt7Jx48YfVdX+49UzeHpYtGgRw8PD/e6GJO1WktwxkXpeapMkdcrgkSR1yuCRJHXK4JEkdcqH\nC3rYtGUri1at63c3ZrTbz35Rv7sgqU+c8UiSOtV58CR5dJLLklyb5MIkmcSxS5IsGa+sLV8/Bd2V\nJE2xfsx4Tgaur6plwC+BoUkcu6T9M16ZJGlA9eMezxbgNUkuq6oVSeYluQT4PWBTVb0pyd7AJcCj\nge9V1WuTvAs4ESDJyVV1dK+yXidMMg/46MhzTPsoJUk9dR48VfW5JHOBS5NcA9wBbK6qs5JcmuQw\n4AHgXOCLwBVJDqiqM5Lc0raxtv18WNkYVo4+R1V9e2SFJCvbeszaZ9w3PkiSdlI/7vEsBq6guTy2\nP/Bm4MT2nsyBwELgV8AK4CLgccDcXTztU3uc4yGqanVVDVXV0Kx583fxdJKksfTjUtsK4F+q6iNJ\nNgPfBH5YVRckeTFwJ/A6mkttnwCuHXHsA8DjAZKkqmqMstFuAb426hySpD7ox8MF7wVOaWcfhwPv\nA05IsgF4A3AXcDVwBvCl9pjtM5SrgZcluQ54/g7KRju/xzkkSX3Qj3s8PwBeMKr45aP2NwBP73Hs\nT4Bjxitry5eP2L6vxzkkSX3gL5BKkjrlK3N6OHThfIZ9pYskTQtnPJKkThk8kqROGTySpE4ZPJKk\nThk8kqROGTySpE4ZPJKkThk8kqROGTySpE4ZPJKkTvnKnB42bdnKolXr+t2NGe92X0sk7ZGc8UiS\nOjUlwZPkrCSvnoq22vZubFcqJclLklwwVW1LkvprUGc8VwDHtttHA1f2sS+SpCk0bcGTZO8kVyT5\n8vYZS5K5SS5PsiHJZUnGusd0Jb9b3O0FwNVJ5iW5pD32vBHtfaGdIX0sydt28bySpGk2nTOeBcC5\nNAGyKMkBwMHAb6rqSOACYO8xjr0RWJLk94H7q+rHwEpgc3vsgiSHAU8D7gaOAJ5SVe/c2fMmWZlk\nOMnwtvu3TtF/AknSaNMZPL8CVgAXAY8D5gLfADYnuQo4Dri/14FVtQ3YCPwtcFVb/FTgxCTrgQOB\nhcAW4Fk0S2W/d1fOW1Wrq2qoqoZmzZu/SwOXJI1tOoPndcAlwEnAfW3ZM4DrquqFwL7A83dw/BXA\nG9pPgFuAc6pqOXAmcCdwPPCOqnpOVV00ReeVJE2jqQyev99+qSrJm4GrgTOAL7VfXwjcDvxFkq8C\nTwCGd9DelcAvaC67AZwPnJBkA00g3QXcBJyb5EtJPp7k6VNwXknSNJqSm+xVdRZwVo8vPb1H2XET\nbPNumtnJ9v37gJePrJNkKfBdmstrewP7VdX6XTmvJGl6par63YeBMzQ0VMPDTookaTKSbKyqofHq\nDerv8UiSZiiDR5LUKYNHktQpg0eS1CmDR5LUKYNHktQpg0eS1CmDR5LUKYNHktQpg0eS1CkXROth\n05atLFq1rt/d0DhuP/tF/e6CpJ3gjEeS1CmDR5LUqb4ET5J3JPlqksuSvDvJ8jHqndNx1yRJ06zz\n4EnyXJoVQJ9Hs6z1yrHqVtXpXfVLktSNfsx4jgM+X81CQFcCtwLHJtmQ5JtJnrC9YpL1I7Yf1a4y\n+pUklyeZl2TvJFck+XKSC9p6c5N8IcmNST6W5G1J5iS5OMm1SS5KMrvjMUuSWv0IngOAnwBU1W3A\n54CnVNWRwKXAUWMctxL4VlUdAXyKZpXRBcC5wDHAoiQHAE8D7gaOaNt9J3AasLmqltEE3amjG0+y\ncvvS3dvu3zplg5UkPVQ/gudemmWqSXI48Fbgo+3X7gTGmo08Dfhau70W+DrNktcrgIuAxwFzgS3A\ns4ANwHvb+gcDN7bbNwAHjW68qlZX1VBVDc2aN38nhyZJGk8/guc64Nh2exnwAHDfBI77DvDsdvtt\nNIHzOuAS4KQRbRwPvKOqnlNVF7VlNwNL2+2l7b4kqQ/6ETyfBW5L8lWahwwumOBx5wPPbO/7PBO4\nELgaOAP4UltnIXATcG6SL7X3hJ4OrAEOSbIBWEwzY5Ik9UHnby5oHyr48zG+tnbU/vIR2w8ALx91\nyAaaez2/leQ04Ls0l+H2Bvarqs00syJJUp+lyQGNNDQ0VMPDw/3uhiTtVpJsrKqh8er55gJJUqcM\nHklSpwweSVKnDB5JUqcMHklSpwweSVKnDB5JUqcMHklSpwweSVKnDB5JUqc6f1fb7mDTlq0sWrWu\n393QOG4/+0X97oKkneCMR5LUqR0GT5K1ST7Rbn88ydrJniDJOTvZt15tvSPJV5NclmTvsc6RZEmS\nJVN1XknS1JnIjOcZoz4npapO35njRkvyXJr1e54HXEWzFPZY51jS/pEkDZiJBM+DSR5Ps74NSeYl\nuSTJhiTntWVHJPlkkkckuT7Jf9h+cLtw2/btR7Uzp68kubxta06Si5Ncm+SiJGMtfX0c8Pl2PZ8r\ngVvHOMe7gFXAqiT/3Jb9XZJXtttnbd+WJHVvIsHzLeAV7Sc0M43NVXUksCDJYVX1FeAXwPuAT1fV\nXWO0tRL4VlUdAXyKZhG309r2ltGEyaljHHsA8BOAqrqtqj7Xq1JVnQGcDZxdVUe3xR8FXtVuHwd8\nZvRxSVYmGU4yvO3+rWN0QZK0qyYSPN8ATmk/AZ4KnNjOMg6kWW4a4DyaEPnHHbT1NOBr7fZa4OvA\nwcCNbdkNwEFjHHsvzYqiJDk8yVsn0HcAqur/Ao9Jspwm5B7oUWd1VQ1V1dCsefMn2rQkaZImGjzP\n5nfBcwtwTrss9ZnAnW35mcC7gLfvoK3vtG0BvA1YAdwMLG3Llrb7vVwHHNtuLwMeFh4jPADMA0iS\ntuzjwIdpZj+SpD6ZSPDcDnwXuKPdPx84IckG4A3AXUn+GPhBVf0X4JAkzxyjrfOBZ7azpWcCFwJr\n2mM2AItpZkK9fBa4LclXaR4yuGAHfb4aeFmS69q6AJcABXxlh6OVJE2rNPfqZ7Ykh9AE1T9W1YfG\nqz9nweJa8Jopewpc08RfIJUGS5KNVTU0Xr094s0FVXUzcHi/+yFJ2kOCZ7IOXTifYX+alqRp4Stz\nJEmdMngkSZ0yeCRJnTJ4JEmdMngkSZ0yeCRJnTJ4JEmdMngkSZ0yeCRJnTJ4JEmd8pU5PWzaspVF\nq9b1uxuaJF8aKu0enPFIkjrVefAkeXOS9UkeaD9PnIZzLEmyZKrblSTtus4vtVXV+4D3Jfleu4rp\ndNgeOt+cpvYlSTup7/d4ksyhWXX0icDdwGur6sF2ldKvA4dV1XG96tEsn70XzSqj+wDHA38JnNi2\nfXJVHT3WOToaoiRphEG4x3MasLmqlgG3Aqe25UuB66vquHHqPaWqjgQuBY6qqjOAs4Gzq+rocY79\nrSQrkwwnGd52/9apH6UkCRiM4DkYuLHdvgE4qN3eXFWXTqDeR9vPO4HZkzzHb1XV6qoaqqqhWfPm\nT3oQkqSJGYTguZlmdkP7eXO7/YsJ1ruvR5sPAPMAkmQHx0qSOjYIwbMGOCTJBmAxzb2YXakHcDXw\nsiTX0dz/mcyxkqRplKrqdx8GzpwFi2vBa87pdzc0Sf4CqdRfSTZW1dB49QZhxiNJ2oP0/XHqQXTo\nwvkM+9OzJE0LZzySpE4ZPJKkThk8kqROGTySpE4ZPJKkThk8kqROGTySpE4ZPJKkThk8kqROGTyS\npE75ypweNm3ZyqJV6/rdDfWBLxqVpp8zHklSpwYieJKcleTVU9DG8inqkiRpmgxE8EiS9hwDeY8n\nyRyaVUKfCNwNvBZ4G7AXzYqi+wDHA78EPgnMAgKsn+ixVXVPZwOSJP3WoM54TgM2V9Uy4Fbg1Lb8\nKVV1JHApcBSwEri8ql4A/GqSxz5EkpVJhpMMb7t/63SNS5L2eIMaPAcDN7bbNwAHtdsfbT/vBGYD\nTwa+1ZYNT/LYh6iq1VU1VFVDs+bNn4oxSJJ6GNTguRlY2m4vbfcB7htV707gkHZ7ySSPlST1wSAF\nz99vv9RFc+/pkCQbgMU092x6WQ38UZL1NPduANZM8FhJUh+kqvrdh4EzZ8HiWvCac/rdDfWBv0Aq\n7bwkG6tqaLx6A/lUW78dunA+w/4DJEnTYpAutUmS9gAGjySpUwaPJKlTBo8kqVMGjySpUwaPJKlT\nBo8kqVMGjySpUwaPJKlTBo8kqVO+MqeHTVu2smjVun53QwPK97lJu8YZjySpUwaPJKlT0xY8SdYm\neWe7fVaSs3axvQ8mOaHd/oskfzOJY09JcsqunF+SNDWme8ZzWpJHTVFb/wP4yySzgD8DPjBF7UqS\nOjTdwbMZ+NPtO0nmJbkkyYYk57Vlw0l+L8m/JVmQ5PO9Gqqq7wP/DvwdcHlV/TzJnCQXJ7k2yUVJ\nZrdtrk/yv5JcObKNJIckuSbJY6ZrwJKkHZvu4DkPeP2I/ZXA5qo6EliQ5DDgNuA44GvAC4Fv7KC9\ns4G/Av6h3T+tbW8ZcCtwalu+FLi+qo4bcewC4CLgpKr6+eiGk6zcvvT2tvu3TnKYkqSJmu7guQf4\nDrC83X8qcGKS9cCBwEKaoHk5sA74E2DjWI1V1c3Av1bVT9qig4Eb2+0bgIPa7c1Vdemow98M3A08\naYy2V1fVUFUNzZo3f6LjkyRNUhdPtf1vYFm7fQtwTlUtB84E7gRuAo4Cvkgz89nRjGe0m2lmN7Sf\nN7fbv+hR9x3AG9tPSVKfTHvwVNVNwLXt7vnACUk2AG8A7qIJmjtoLrn9sKrumETza4BD2vYWA2t3\nUPf/VdVdwHeSvGRyo5AkTZVUVb/7MHDmLFhcC15zTr+7oQHlmwuk3pJsrKqh8er5ypweDl04n2H/\ncZGkaeGbCyRJnTJ4JEmdMngkSZ0yeCRJnTJ4JEmdMngkSZ0yeCRJnTJ4JEmdMngkSZ0yeCRJnfKV\nOT1s2rKVRavW9bsbGnC+s03aObvtjCfJSUnGXTgnyfIOuiNJmqCBm/Ek+QjNmjnPB2ZV1Zq2/ACa\nhd9+1VZ9LvD8JB9r9/cCbqmqH4xq8tQkj62qT09/7yVJ4xm44KEJll+3nyPXbHgs8J+AB9v9W9rP\nJe3nbODfk/xnmiWw72+Pnwe8NcnpQNr9D1TVh6dzEJKk3gYmeJLMqqptPcr3BT4E/HVVvSfJWmDR\nqGoPVNUJ7fZm4AMjjj8d+FlVrZ2OfkuSJmcggqe9V/PpJNuAg4D/1n7pJcCrgH+oqtvasqdV1dJR\nx984av9k4PXt7hOBXydZ0e6/u9dltyQrgZUAs/bZf9cHJUnqaSCCp6q2Ai8ASLJmxJf+D3BmPXSZ\n1Fm9mhi1vz+wpqrWjpzxtNv7jtGH1cBqaFYg3bmRSJLGMxDBswO31sPX5r45yXqaAHks8H3gp6Pq\n/GYHbRoqktRHAxU8SZ4ALOxR/siq+nW7exNwDbAFWA5sonmwYKSHPSaeZB9gP+BHU9hlSdIkDUTw\nJDmW5hHq7/C7S2HbgP/Ybq9I8niamczhwCtpHrcGuBz4pyTPAt5SVb8B7uV3s6BsbwM4BDh3Goci\nSRrHoPwC6QZgWVWdAnyPZgazAXhOe1ntD4ELgccDfwI8G/gr4J6qug/4I+AHwByAqlpTVZ9p294L\nmF1V76mqE6vq3zoblSTpYfLwWyiDr539PAm4qcc9oF02NDRUw8PDU92sJM1oSTZW1dB49QbiUttk\nVdWPgR/3ux+SpMkblEttkqQ9hMEjSeqUwSNJ6pTBI0nqlMEjSeqUwSNJ6pTBI0nqlMEjSeqUwSNJ\n6tRu+eaC6bZpy1YWrVrX725oN3T72S/qdxekgeeMR5LUqYENniSPTnJZkmuTXJgk4x81bpvrp6Br\nkqRdMLDBA5wMXF9Vy4BfAuO+8VSSNPgGOXi2ACcmWVxVK2iWvL4kyYYk5wEkmZPk4nZWdFGS2UnO\nSrK8/fopSU7p3xAkSaMN7MMFVfW5JHOBS5NcA9wBbK6qs5JcmuQw4Mi27KQkZwGn7uz5kqwEVgLM\n2mf/XR+AJKmngZ3xJFkMXAEsAfYH3kwzA1oPHAgsBA4GbmwPuQE4aFQzcyd6vqpaXVVDVTU0a978\nXey9JGksAxs8wArgxKraBmwGPgicU1XLgTOBO4GbgaVt/aXt/oM0QQVwfJcdliSNb2AvtQHvBS5K\n8lpgK/Aq4IJ2/952fw2wNskG4C7gncAfAO9PcjSuUipJA2dgg6eqfgC8YFTxy3tUPWnU/maaez+9\n2ly+6z2TJO2KQb7UJkmagQZ2xtNPhy6cz7CvPpGkaeGMR5LUKYNHktQpg0eS1CmDR5LUKYNHktQp\ng0eS1CmDR5LUKYNHktQpg0eS1CnfXNDDpi1bWbRqXb+7IUmdur2jN7Y445EkdWq3Cp4kGbF9YJLH\nT+CY5dPaKUnSpAxk8CRZn2T2qLLZwDVJTmyLzgZem+SY9s9xSfbt0dypSV463X2WJE3MoN7j2beq\nHhxZUFUPtqHz10n+BZgH3AM8oa0yG5iT5I3AqcD9QLX13prkdCDt/geq6sPdDEWSNNKgBk9t32gv\nr80CDgXuA94OXEEzWztlxDH/VFX3AB9o/2w//nTgZ1W1dtp7LUka16AGD0luaDcfAQwD7wfeA6wF\n3gD8V5oQehmwjhGrkyY5GXh9u/tE4NdJVrT7766qT/c430pgJcCsffaf4tFIkrYb2OCpqqU9il+c\n5LHAeTTLYi8EHgO8Atg/yTerah2wP7CmqtaOnPG0273uA1FVq4HVAHMWLK5edSRJu25gg6eXJEPA\nK2nu4XwQ+BDwm/bLh9JcgmNEWS+GiiT10UA+1bYDbwQ+TvOAwC+ATcBSYC7wQFVta+s9bFxJ9gH2\nA37dTVclSb0MxIwnySOBGhEco78+C3gy8OSqGk7yBOAg4FNtldOAB5N8pqq2AvcCP91+ePu5AjgE\nOHeahiFJmoBU9f/KU3vjfyVjXyJ7BM0DBNdX1VWjjv0D4GLgpVV1V4+2/4bmHs/qifZnaGiohoeH\nJ1pdkgQk2VhVQ+PVG4gZT1WtAdbs5OG3As+tql+O0fb/3OmOSZKm3EAEz66oZsrWM3QkSYNnd3u4\nQJK0mzN4JEmdMngkSZ0aiKfaBk2SnwO39LsfHdkP+FG/O9ERxzoz7Slj3R3G+aSqGvedY7v9wwXT\n5JaJPBI4EyQZdqwzj2OdeWbSOL3UJknqlMEjSeqUwdPbhN9yMAM41pnJsc48M2acPlwgSeqUMx5J\nUqcMHmk3luRxSY5Nsl+/+yJNlMEzSpIPJbk+yZn97stUSnJAki+323sl+VyS65KcOlbZ7ijJ/CRf\nSHJVksuSzO71PZ0J3+ck+wKXA4cD1yTZf6aOFX77d/imdntGjjPJI5PcmWR9++fQJH+X5OtJzhtR\n72FluxODZ4QkLwNmVdVzgAOTLO53n6ZC+w/UR4BHt0V/DmysqucBf5zkMWOU7Y7+FHhPVb0QuIdm\nxdqHfE9n0Pf5MOAtVfXfgSuBo5i5YwV4NzC315hm0DgPAy6uquVVtRyYDRxB88PFD5Mck+RZo8v6\n1tudZPA81HLgE+32VTTf3JlgG/AKmgXy4KHj3AAMjVG226mq91fV1e3u/sCrefj3dHmPst1OVV1b\nVTckOZLmH6HjmKFjTXIUcB/NDxPLmaHjpFlR+cVJvpbkQ8DRwKfat/BfCTwfWNajbLdi8DzUo4Et\n7fZPgAP62JcpU1X3tiuzbtdrnDNq7EmeA+wL3MUMHmuS0PxQ8VOgmIFjTTIbeDuwqi2ayX9/vw4c\nU1WHA3sBc5mBYzV4HuoXNN9ogL2Zuf99eo1zxow9yeNoljg/lRk+1mq8Cfg28Fxm5lhXAe+vqp+1\n+zP5e/rtqvrXdnuYGTrW3a7D02wjv5uiPwO4vX9dmVa9xjkjxt7+dPxJ4IyquoOZPda/TfJn7e5j\ngbOZmWM9BnhTkvXAEuAPmZnjBLgwyTOSzAJeSjO7mXFj9RdIR0iyD/Bl4J+BE4Cloy5R7daSrK+q\n5UmeBHwe+CLNT8lLgd8fXVZV2/rW2Z2U5I3AO4FvtUUXAG9hxPeU5pLUbv99bh8a+QQwB9gMnEFz\nf27GjXW7NnxewqgxMUPGmeTpwMeAAJ+lucT4ZZrZz/HtnztGl1XV9/vS4Z1k8IzS/s98LLChqu7p\nd3+mS5In0vzUdOX2/0F7lc0Evb6nM/X7vKeMdU8ZJ0CSucCLgG9U1W1jle1ODB5JUqe8xyNJ6pTB\nI0nqlMEjSeqUwSNJ6pTBI0nq1P8HXZCJ7b4fO6EAAAAASUVORK5CYII=\n",
      "text/plain": [
       "<matplotlib.figure.Figure at 0x23198f79978>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "city_count.plot(kind='barh')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 36,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Brand</th>\n",
       "      <th>Store Number</th>\n",
       "      <th>Store Name</th>\n",
       "      <th>Ownership Type</th>\n",
       "      <th>Street Address</th>\n",
       "      <th>City</th>\n",
       "      <th>State/Province</th>\n",
       "      <th>Country</th>\n",
       "      <th>Postcode</th>\n",
       "      <th>Phone Number</th>\n",
       "      <th>Timezone</th>\n",
       "      <th>Longitude</th>\n",
       "      <th>Latitude</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2091</th>\n",
       "      <td>Starbucks</td>\n",
       "      <td>22901-225145</td>\n",
       "      <td>北京西站第一咖啡店</td>\n",
       "      <td>Company Owned</td>\n",
       "      <td>丰台区, 北京西站通廊7-1号, 中关村南大街2号</td>\n",
       "      <td>北京市</td>\n",
       "      <td>11</td>\n",
       "      <td>CN</td>\n",
       "      <td>100073</td>\n",
       "      <td>NaN</td>\n",
       "      <td>GMT+08:00 Asia/Beijing</td>\n",
       "      <td>116.32</td>\n",
       "      <td>39.90</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2092</th>\n",
       "      <td>Starbucks</td>\n",
       "      <td>32320-116537</td>\n",
       "      <td>北京华宇时尚店</td>\n",
       "      <td>Company Owned</td>\n",
       "      <td>海淀区, 数码大厦B座华宇时尚购物中心内, 蓝色港湾国际商区1座C1-3单元首层、</td>\n",
       "      <td>北京市</td>\n",
       "      <td>11</td>\n",
       "      <td>CN</td>\n",
       "      <td>100086</td>\n",
       "      <td>010-51626616</td>\n",
       "      <td>GMT+08:00 Asia/Beijing</td>\n",
       "      <td>116.32</td>\n",
       "      <td>39.97</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2093</th>\n",
       "      <td>Starbucks</td>\n",
       "      <td>32447-132306</td>\n",
       "      <td>北京蓝色港湾圣拉娜店</td>\n",
       "      <td>Company Owned</td>\n",
       "      <td>朝阳区朝阳公园路6号, 二层C1-3单元及二层阳台, 太阳宫中路12号</td>\n",
       "      <td>北京市</td>\n",
       "      <td>11</td>\n",
       "      <td>CN</td>\n",
       "      <td>100020</td>\n",
       "      <td>010-59056343</td>\n",
       "      <td>GMT+08:00 Asia/Beijing</td>\n",
       "      <td>116.47</td>\n",
       "      <td>39.95</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2094</th>\n",
       "      <td>Starbucks</td>\n",
       "      <td>17477-161286</td>\n",
       "      <td>北京太阳宫凯德嘉茂店</td>\n",
       "      <td>Company Owned</td>\n",
       "      <td>朝阳区, 太阳宫凯德嘉茂一层01-44/45号, 东三环北路27号</td>\n",
       "      <td>北京市</td>\n",
       "      <td>11</td>\n",
       "      <td>CN</td>\n",
       "      <td>100028</td>\n",
       "      <td>010-84150945</td>\n",
       "      <td>GMT+08:00 Asia/Beijing</td>\n",
       "      <td>116.45</td>\n",
       "      <td>39.97</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2095</th>\n",
       "      <td>Starbucks</td>\n",
       "      <td>24520-237564</td>\n",
       "      <td>北京东三环北店</td>\n",
       "      <td>Company Owned</td>\n",
       "      <td>朝阳区, 嘉铭中心大厦A座B1层024商铺, 金融大街7号</td>\n",
       "      <td>北京市</td>\n",
       "      <td>11</td>\n",
       "      <td>CN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>GMT+08:00 Asia/Beijing</td>\n",
       "      <td>116.46</td>\n",
       "      <td>39.93</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "          Brand  Store Number  Store Name Ownership Type  \\\n",
       "2091  Starbucks  22901-225145   北京西站第一咖啡店  Company Owned   \n",
       "2092  Starbucks  32320-116537     北京华宇时尚店  Company Owned   \n",
       "2093  Starbucks  32447-132306  北京蓝色港湾圣拉娜店  Company Owned   \n",
       "2094  Starbucks  17477-161286  北京太阳宫凯德嘉茂店  Company Owned   \n",
       "2095  Starbucks  24520-237564     北京东三环北店  Company Owned   \n",
       "\n",
       "                                 Street Address City State/Province Country  \\\n",
       "2091                  丰台区, 北京西站通廊7-1号, 中关村南大街2号  北京市             11      CN   \n",
       "2092  海淀区, 数码大厦B座华宇时尚购物中心内, 蓝色港湾国际商区1座C1-3单元首层、  北京市             11      CN   \n",
       "2093        朝阳区朝阳公园路6号, 二层C1-3单元及二层阳台, 太阳宫中路12号  北京市             11      CN   \n",
       "2094          朝阳区, 太阳宫凯德嘉茂一层01-44/45号, 东三环北路27号  北京市             11      CN   \n",
       "2095              朝阳区, 嘉铭中心大厦A座B1层024商铺, 金融大街7号  北京市             11      CN   \n",
       "\n",
       "     Postcode  Phone Number                Timezone  Longitude  Latitude  \n",
       "2091   100073           NaN  GMT+08:00 Asia/Beijing     116.32     39.90  \n",
       "2092   100086  010-51626616  GMT+08:00 Asia/Beijing     116.32     39.97  \n",
       "2093   100020  010-59056343  GMT+08:00 Asia/Beijing     116.47     39.95  \n",
       "2094   100028  010-84150945  GMT+08:00 Asia/Beijing     116.45     39.97  \n",
       "2095      NaN           NaN  GMT+08:00 Asia/Beijing     116.46     39.93  "
      ]
     },
     "execution_count": 36,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "china_data = data[data['Country'] == 'CN']\n",
    "china_data.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "上海市            542\n",
       "北京市            234\n",
       "Taipei City    126\n",
       "杭州市            117\n",
       "深圳市            113\n",
       "广州市            106\n",
       "Hong Kong      104\n",
       "成都市             98\n",
       "苏州市             90\n",
       "南京市             73\n",
       "Name: City, dtype: int64"
      ]
     },
     "execution_count": 37,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "city_count = china_data['City'].value_counts()[0:10]\n",
    "city_count"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 38,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<matplotlib.axes._subplots.AxesSubplot at 0x23198a83160>"
      ]
     },
     "execution_count": 38,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAZ4AAAD6CAYAAACRbiH3AAAABHNCSVQICAgIfAhkiAAAAAlwSFlz\nAAALEgAACxIB0t1+/AAAADl0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uIDIuMS4wLCBo\ndHRwOi8vbWF0cGxvdGxpYi5vcmcvpW3flQAAHOZJREFUeJzt3XucHVWB7fHfokkiAZIAiUBQaXVQ\nEfHZIiJIoyDwAQUcn9dhLsYYZLxq9AoT7tUZ9TrKKMZR1NzJBAwqiCOOqGRGRYcII4p2YDTKiC+C\nGsErr/AIAknW/aN2k8PJ6UeSPtXVnfX9fPI5Vfvs2rU3Dazsqurask1ERERddhrvDkRExI4lwRMR\nEbVK8ERERK0SPBERUasET0RE1CrBExERtUrwRERErRI8ERFRqwRPRETUaufx7kATzZ492729vePd\njYiICWXVqlW32Z4zUr0ETwe9vb0MDAyMdzciIiYUSTePpl4utUVERK0SPBERUasET0RE1CrBExER\ntcrDBR2sXruO3kUrxrsbo7LmnBPGuwsREVulkTMeSc+S9JIR6rxW0sxRtNU/Zh2LiIjt1ogZj6Rn\nAicA6wEDzwOmSnpqqbITsKp8PlTKDgOOkHRx2Z8C3Gj7923Nz5M0y/Zl3RxDRESMTiOCB1gL/Cvw\nALAJeC5wMfDT8n0PsBvwAuDBUnZj+Xxm+ZwK/FHSScA8NofYdOBMSQsBlf0lti/o5oAiIqKzpgRP\nD/DRlv2DgMezOWQ22D4auFbScqC37fj7bR9ftn8CLBn8ogTOXbaXj323IyJiazUleACw3S/pbOCl\nVDOT19leLOnalmpPsX1o63Ft3yPpVOD0sjsX2CBpftk/t9NlN0kLgAUAPTNGfONDRERso6Y8XPAn\nAEmPpbqH8zLg74EeSY9h830dqGZH7dy2PwdYZvtw4OPAB8r2pcAenTpge6ntPtt9PdNHfGYhIiK2\nUaNmPFSBsR44ruzfB+zbVuenklZSBcgs4CbgzrY6m4Y5R3tIRUREjZoWPG8FHgfsU/b3BZ7cVud6\n4EqqBxL6gdVUDxa02mImJ2kGMBu4bey6GxERW6spwTMVwPZpAIP3Y2wvK/v/UT7PBg4BXgMcUY69\nHPicpOcA77C9CbibzbMglc/5VA8tnNflsURExDCaco9nl7b9m4CbASR9FLhF0mxgL+CVVI9bvx24\n1fZ9wJ8DvwemQRVYtr9S2poCTLW92PYptv/Q9dFERMSQZDf7lockua2TkvYC9geub/9uLPT19Tnr\n8UREbB1Jq2z3jVSvKZfahtQpWGzfDtw+Dt2JiIjt1JRLbRERsYNI8ERERK0SPBERUasET0RE1CrB\nExERtUrwRERErRI8ERFRqwRPRETUKsETERG1avybC8bD6rXr6F20Yry7MabWnHPCeHchIgLYAWY8\nkvrHuw8REbFZI4JH0k6qHCJpaUv5deVTknYq22dJOq7t+B5J1wzR/DxJJ3et8xERsVWacqntVOD1\nwO7APmWFUYA/K9s7AZ8EvkC1gugDAJKutH2U7Y2S7i9lZwDzqFYyNTAdOFPSQqq1eaYDS2xfUNPY\nIiKiRSOCx/aFwIWSngWcDNwDfAy4GHhV2xuqzeblq+9rK8f2EmDJYGEJnLtsL+/aACIiYtQaETwA\nkr5PNZMx8EzgxPLVacCnS53LgZXAiWUpayS9D/hwW1unAqeX3bnAhsFVTYFzbV/W4fwLgAUAPTPm\njNWwIiKiTWOCB3gR8BTgF8Bltl8s6VXAwZKeDPwSeBTV5bIfUK1ECjBACYwWc4Bltpe3znjK9h6d\nTm57KbAUYNq+BzR7dbyIiAmsEQ8XFGdQXWY7FvheKduLagZ0MdAHXAfsDdwADD7vvAJY29bWpmHO\nk1CJiBhHjQgeSU+kCpa/B84E/ql8tRdV2LwdWG/7LOCpwI22LwGwvXFwu8UW4yqX5mYDG7oyiIiI\nGJVGBI/tXwHvA74OLLZ9s6TnAIcBf7B9le3Vkp4E3GH7oXKohmjybuDOtjrzgYOAK7oyiIiIGJUm\n3eN5AfA3tq8s+88GLgeubanzUeCdLfu3QPV7PFSPSQNge1lLnSnAVNuLgcWj6cjB+81kIL/pHxHR\nFXrkk8rNJmm67fXdPk9fX58HBga6fZqIiElF0irbfSPVa8SlttGqI3QiIqK7JlTwRETExJfgiYiI\nWiV4IiKiVgmeiIioVYInIiJqleCJiIhaJXgiIqJWCZ6IiKhVk16Z0xir166jd9GKkStOcGvyWqCI\nGAeZ8URERK0mffBI6h/vPkRExGaNvdQm6WPAhcDbgLfZvquUz6da6O0rwIuplraeXQ47z/Yf2pqa\nJ2lWp+WuIyKifk2e8TyqfC4H/rsqXwIWUi2N8HXgXuAE4BNUS2ffJukMST+U9B1JK6mW0z5T0spS\n9kNJ8+oeTEREVBoz45G0HHgicF8peiLwTOAuYBrwJaqVSE8BHgfsD6wGHgB2AX5seyOwpPwZbHch\ncJft5XWMIyIihteY4KG6fPZG2z8DkPRm4HfAT4BnUC30diTwGKpA+jzVLAfgZOCbgw1JOhU4vezO\nBTaUS3QA53a67CZpAbAAoGfGnDEdWEREbNakS20GLpJ0naRlwFrgCcA8YKbtn5eyeVSX4f4C+HU5\n9vPA6ZKmlf05wDLbhwMfBz5Qti8F9uh4cnup7T7bfT3TZ3ZnhBER0ajg2QV4OfAm4DbgR8DxVEti\nf6Y8nfZu4P3Aq6keLtgTwPatwL8AryxtbRrmPBNnydWIiEmoScHzOOB2YCZwB7CG6hLbBwBsrwTe\nCzyb6tLas4GNAJIOpXrI4MHS1hbjkjSD6um3Dd0bQkREjKQR93hKKMwADgc+BPwtsAy4Gngp8OhS\n5ybgucBjgX2ALwIC7gEWl3ACuBu4c7D58jkfOAg4r8vDiYiIYcge/ytPkv6aavbyj8DTgE8CH7F9\nkaSLgOOA11Hd25lle7mk06gC5k22XzJM22dRPdW2dLT96evr88DAwDaPJyJiRyRple2+Ees1JHim\nANh+SJKAfWzf0vL9k2z/XNJOVH3e2M3+JHgiIrbeaIOnEZfabD/Usm3glrbvf14+h3toICIiJoAm\nPVwQERE7gARPRETUKsETERG1SvBEREStEjwREVGrBE9ERNQqwRMREbVK8ERERK0a8QukTbN67Tp6\nF60Y727Ubs05J4x3FyJiB5AZT0RE1GrMgkfSckmHl+13lZd4jilJKyU9RtJcST+VtO9YnyMiIrpr\nIs54dgI+ByxsfZFoRERMDF29xyNpT+BCYBawyvZCScuplqw+BugBXky1Fs8XqZY9uBH4ju1lQzT7\nN8D1tq8o53g81do9uwBftv1hSSuBFcApVKuZngQcCFxQ2vg5cKntr47pgCMiYkRjPeM5r/xP/w1l\n/38Bl9g+Apgp6bhSvlsp+xnwLOAw4BtUQTFrmNABeCHVgm6DPkwVRi8AjpV0YCm/z/ZhwG7AvsCx\nVIvA/U9gXXvoSFogaUDSwMb167Zh6BERMRpjHTxvsd0PnF/2nwpcW7avpZp1QDULAvgNMJVqBvQK\n4AvAx0Y4x0nAdElHlP0DgWvLcgoDwFOGOMevgLcAf9fSv4fZXmq7z3Zfz/SZI480IiK2Sbfv8fwU\nOLRsH1r2Ae5rq3cSMM/24ba/NUKb9wDvogoQgBuAQ8sCcs8F/gvAdvs5TgaOt91v+z+3eiQRETEm\nuh08HwReI+k/qJaf/uYQ9VYBX5L0bUmfkbTfcI3avgr4k6TjgbOA9wHXAF+3/bNhzvFdSVdI+kdJ\nu2/TiCIiYruM2cMFtk9r2X5/y1cnDlPvPQCS3kN1KWwjsCfVwwhrO5yjv2X7JS1fvWiYeqeVczwd\n+B3wENU9n12pZk8REVGjRry5YDCAunyO07t9joiIGFkjgqdpDt5vJgN5fUxERFdMxF8gjYiICSzB\nExERtUrwRERErRI8ERFRqwRPRETUKsETERG1SvBEREStEjwREVGrBE9ERNQqwRMREbXKK3M6WL12\nHb2LVox3N8bFmrwqKCK6rJEzHknPkHT4GLXVPxbtRETE2Ghk8AD3Au/v9IWks1qW0B4s65F0zRBt\nzZN08lh3MCIitk1jLrVJWgD8JbChFO0iaWXZfhTwAdtfBQw8UI650vZRtjdKur+UnQHMA9aXutOB\nMyUtBFT2l9i+oJ6RRUREq8YED9Xib0tsXzRCPZc/8MgltA1gewmwZLCwBM5dtpePXVcjImJbNSl4\nNgI9w1WQdDmwEjhR0oxS9j7gw231TgUGF36bC2yQNL/sn2v7sg5tLwAWAPTMmLPto4iIiGE16R5P\nD5tnMluQ1EN1yU3AD4BXlq8GKIHRYg6wzPbhwMepLtMdDlwK7NGpfdtLbffZ7uuZPnO7BhIREUNr\nUvDsBawb5vte4Dpgb+AGYPB55xXA2ra6m4ZpZ8hwi4iI7mtS8BwC/GyoL23/yvZZwFOBG21fUso3\nDm632GJc5dLcbDY/vBAREeOgEcEj6XnATNs/H6Hek4A7bD80WDRE1buBO9vqzAcOAq7Yzu5GRMR2\naMrDBQLePop6HwXe2bJ/Czx8/2f6YKHtZS11pgBTbS8GFm9/VyMiYnvInji3PCRNt72+2+fp6+vz\nwMBAt08TETGpSFplu2+keo241DZadYRORER014QKnoiImPgSPBERUasET0RE1CrBExERtUrwRERE\nrRI8ERFRqwRPRETUKsETERG1SvBEREStmvKutkZZvXYdvYtWjFxxB7DmnBPGuwsRMck0ZsYj6QhJ\nQ71tenva7R/rNiMiYts1acbTC5wuaW+2XO7gQKAf2B94se2zJZ0HLLZ9E4CkbwPH2m5fb2eepFmd\nlruOiIj6NSZ4bH9W0jXAJ4A3AM8DrgWOAZ5MtYDbn4AHyiG7AUi6AjgW+JPtDZLOAOYB66lWG50O\nnClpIVWgTQeW2L6grrFFRMRmjQgeSS8FjgTOBk4HlgNvAW6nCp5vUQXNa4ADSv0HgY3AA7Y3STKA\n7SXAkpa2FwJ32V5e13giImJojQge21+TNB14ATAHWEi1TPXpVCuHvgz4HfBdqlnM9cDLgYc6tSfp\n1HIswFxgg6T5Zf/cTpfdJC0AFgD0zJgzNgOLiIgtNCJ4AGx/oTxc8F6qsNkLeDTV/Z2dgbuA3wK3\n2/5duRd07xDNzQGW2V7eOuMp23sMcf6lwFKAafseMHFWx4uImGCa9FTbNOAztv8G+N/ANKpg+Yrt\nY2x/s1SdImk2sKvte4ZobtMwp0qoRESMo8bMeIBTgWskPQr4EPBu4HDgNeWJtacDf0X1gMELqe7/\nQOfw3KJM0gyqy3e3jX3XIyJitBox45E0BXgr8FXgS8B5VPd0NgBvBL4A3AScbPsE4ERg8Km0NZJ6\ngB5Jg+O5G7hzsPnyOR84CLiiu6OJiIjhNGXG00sVOLcDH7H975KeD+xi+xeSjgHuLE+v7QxcZvty\nANt/BSDp04ON2V7W0vYUYKrtxcDi0XTm4P1mMpDf2I+I6ArZueXRrq+vzwMDA+PdjYiICUXSKtt9\nI9VrxKW2iIjYcSR4IiKiVgmeiIioVYInIiJqleCJiIhaJXgiIqJWCZ6IiKhVgiciImqV4ImIiFo1\n5ZU5jbJ67Tp6F60Y7240ypq8QigixkhjZzyq7DoG7fSPQXciImKMNCZ4JM2QdFFL0eOBizvUO0vS\ncW1lPZKuGaLpeZJOHsOuRkTEdmjEpTZJjwaeAOwu6UnAx6jeKr2bpG9RLW3wOtu3Ui3k9kA57krb\nR9neKOn+UnYGMA9YX+pOB84sq4+q7C+xfQEREVG7RgQP1bIIb6Ca5RwFvML2fYNflqUQNpZds3kV\n0fta2jCA7SXAkpZjH176ukt9j4iIrdCI4LH9A0mHAY8GLgP2kvSV8vXttl8NIOlyYCVwYllRFEnv\nAz7c2p6kU4HTy+5cYIOk+WX/XNuXdXM8ERExtMbc4wFOAR5HFSKPAn5k+2hgV6ju45RyAT8AXlmO\nGwAWtLU1B1hm+3Dg48AHyvalwB6dTi5pgaQBSQMb168b04FFRMRmjQgeSa8CrgF+BHwR2B24t61a\nL3AdsDdwAzD4vPMKYG1b3U3DnK7jyne2l9rus93XM33mVvU/IiJGrxHBA9wMfBLA9teApwBrWivY\n/pXts4CnAjfavqSUbxzcbrHFuMqludnAhjHvfUREjFojgsf2tVRPqknSNOAM4Iry9TRJh0h6U3ni\n7Q7bD5XvNESTdwN3ttWZDxzU0m5ERIyDRjxcUEwBpgGLgMts/66UXwicCnwK+CjwzpZjboGH7/9M\nHyy0vayt3am2FwOLu9b7iIgYFdkdb3mMG0k72+54OUzSdNvru92Hvr4+DwwMdPs0ERGTiqRVtvtG\nqteIS22thgqd8l3XQyciIrqrccETERGTW4InIiJqleCJiIhaJXgiIqJWCZ6IiKhVgiciImqV4ImI\niFoleCIiolYJnoiIqFWT3tXWGKvXrqN30YqRK+7g1pxzwnh3ISImoMx4IiKiVsMGj6T/IWmlpPvL\n5ykj1P+Hbe3IaI6VdIak70v6hqS5Qx0rqVdS/7b2JSIiumfY4LH9Cdv9wFrb/ba/PEL9hdvakZGO\nlfRY4K3AC4F/oFo+Yahje4H+be1LRER0z1ZfapO0m6SvS7pa0qfbvlvZsv0eSf8m6TuSLpW0syr/\n1FLW0+nYIRwNXGn7QeD7wMPrFrSd921UwXRamaXNkfR6SYvK96cNbkdERP225R7PvsB5VEHQK2nv\nYepebftI4A/ASeXPlFL2G2Br7k7vDdwBYPtO25/pVMn2x4CFwPIyS/sjcClwcqnyCuBz7cdJWiBp\nQNLAxvXrtqJbERGxNbYleB6iWkb6ImBPYJdh6q4qnz+muvz1ZOD5ZYbyQqowGa27gd2guuwm6aOj\nPdD2PcCvJB0J7NSyumlrnaW2+2z39UyfuRXdioiIrbEtwfMGqhnEa4H7Rqh7SPl8FvBL4EbgknLf\naCFww1ac97vAUeXy3KHAxmHq3k9ZCluSStlngE8Dn9+Kc0ZExBjbluC5Ajgb+Peyv98wdZ9bZjez\ngMuBrwJzJX0HeD9w82hPavtHwCXANcCbgI8MU/164MmSrgZeXcq+BUwB/mW054yIiLE3ql8gtf1n\nLdtXAU8bol5/W9Fi2yvbyt44ymM71fkg8MGRji0PIJw0uC9pT6rgO9/2SLO0iIjooq69ucD2e7rV\n9tayfQdw2Hj3IyIi8sqcjg7ebyYDeR1MRERX5JU5ERFRqwRPRETUKsETERG1SvBEREStEjwREVGr\nBE9ERNQqwRMREbVK8ERERK0SPBERUasET0RE1CqvzOlg9dp19C5aMd7diIZbk9cqRWyTCTvjkfRa\nSSOu2Capv4buRETEKDVuxiPpQuD/AEcAPbaXlfK9gadSrYAK1dumj5B0cdmfAtxo+/dtTc6TNMv2\nZd3vfUREjKRxwUMVLBvKp1vKZ1GtZPpg2b+xfD6zfE4F/ijpJGAesL4cPx04U9JCQGV/ie0LujmI\niIjorDHBI6nH9hbLWUvaAzgfeKftxZKWA71t1e63fXzZ/gmwpOX4hcBdtpd3o98REbF1GhE85V7N\nZZI2AgdSLYsN8DLgvwEft/3rUvYU24e2HX9t2/6pwOlldy6wQdL8sn9up8tukhYACwB6ZszZ/kFF\nRERHjQge2+uAowAkLWv56r+Ad9luveTW06mJtv05wDLby1tnPGV7jyH6sBRYCjBt3wPa24uIiDHS\niOAZxi/aQgfgp5JWUgXILOAm4M62OpuGaTOhEhExjhoVPJL2AfbrUL6z7Q1l93rgSmAt0A+spnqw\noNUWj4lLmgHMBm4bwy5HRMRWakTwSDqG6hHqn7H5UthG4HFle76kvahmMocAr6F63BrgcuBzkp4D\nvMP2JuBuNs+CNNgGcBBwXheHEhERI2jKL5BeBRxp+zTgl1QzmKuA55fLai8FPgvsBbwSeC7wduBW\n2/cBfw78HpgGYHuZ7a+UtqcAU20vtn2K7T/UNqqIiNiCtryF0nxl9rM/cH2He0Dbra+vzwMDA2Pd\nbETEpCZple2+keo14lLb1rJ9O3D7ePcjIiK2XlMutUVExA4iwRMREbVK8ERERK0SPBERUasET0RE\n1CrBExERtUrwRERErRI8ERFRqwn5C6TdtnrtOnoXrRjvbkRE1GrNOSfUcp7MeCIiolYTKngkqWX7\nCeWdbSMd09/VTkVExFZpZPBIWilpalvZVOBKSaeUonOA10s6uvw5VlKn1UXnSTq5232OiIjRaeo9\nnj1sP9haYPvBEjrvlHQDMB24FdinVJkKTJN0BjAPWE+12uh04Myy7LXK/hLbF9QzlIiIaNXU4Hl4\nqYNyea0HOBi4D3g38HWq2dppLcd8zvatwJLyZ/D4hcBdtpd3vdcRETGipgYPkr5fNncCBoBPAYuB\n5cCbgL+lCqGXAyuAV7UceypwetmdC2yQNL/sn2v7sg7nWwAsAOiZMWeMRxMREYMaGzy2D+1QfKKk\nWcAngaOA/YDdgVcDcyT9p+0VwBxgme3lrTOest3pPhC2lwJLAabte8DEWx0vImKCaGzwdCKpD3gN\n1T2c/wucD2wqXx9MdQmOlrJOEioREeOokU+1DeMM4BKqBwTuBVYDhwK7APfb3ljqbTEuSTOA2cCG\neroaERGdNGLGI2lnwC3B0f59D/B44PG2ByTtAxwIfKlUeSPwoKSv2F4H3A3cOXh4+ZwPHASc16Vh\nRETEKMge/ytP5cb/Aoa+RLYT1QME37P9zbZjnwR8HjjZ9m87tH0W1T2epaPtT19fnwcGBkZbPSIi\nAEmrbPeNVK8RMx7by4Bl23j4L4DDbD8wRNsf2uaORUTEmGtE8GwPV1O2jqETERHNM9EeLoiIiAku\nwRMREbVK8ERERK0a8VRb00i6B7hxvPtRk9nAbePdiZpkrJPTjjLWiTDO/W2P+M6xCf9wQZfcOJpH\nAicDSQMZ6+STsU4+k2mcudQWERG1SvBEREStEjydjfotB5NAxjo5ZayTz6QZZx4uiIiIWmXGExER\ntUrwRExgkvaUdIyk2ePdl4jRSvC0kXS+pO9Jetd492WsSdpb0tVle4qkr0n6rqR5Q5VNNJJmSvo3\nSd+U9GVJUzv9TCfDz1nSHsDlwCHAlZLmTNaxwsP//l5ftiflOCXtLOk3klaWPwdLeq+kH0r6ZEu9\nLcomkgRPC0kvB3psPx94gqQDxrtPY6X8T+pCYNdS9BZgle0XAK+QtPsQZRPN64DFtl8C3Eq1Yu0j\nfqaT6Of8dOAdtv8O+AbwIibvWAHOBXbpNKZJNM6nA5+33W+7H5gKHE71l4v/J+loSc9pLxu33m6j\nBM8j9QP/XLa/SfXDnSw2Aq+mWiQPHjnWq4C+IcomFNufsn1F2Z0D/AVb/kz7O5RNOLa/Y/v7kl5I\n9T+hY5mkY5X0IuA+qr9M9DNJx0m1ovKJkn4g6XzgxcCXylv4vwEcARzZoWxCSfA80q7A2rJ9B7D3\nOPZlTNm+u6zOOqjTWCfN+CU9H9gD+C2Te5yi+gvFnYCZhGOVNBV4N7CoFE3mf3d/CBxt+xBgCrAL\nk3CsCZ5HupfqBw2wG5P7n0+nsU6K8Uvak2qJ83lM4nFCtR6V7TcDPwYOY3KOdRHwKdt3lf3J/DP9\nse1byvYAk3SsE67DXbaKzVP0ZwBrxq8rXddprBN+/OVvx18EzrZ9M5N0nACS/lrSX5bdWcA5TM6x\nHg28WdJK4JnAS5mc4wT4rKRnSOoBTqaa3Uy6seYXSFtImgFcDXwbOB44tO3y1IQnaaXtfkn7A/8K\nfIvqb8qHAo9pL7O9cdw6uw0knQF8APhRKfo08A5afqZUl6Qm/M+5PDDyz8A04CfA2VT35ibdWAeV\n8HkZbWNikoxT0tOAiwEBX6W6xHg11eznuPLn5vYy2zeNS4e3UYKnTfmP+RjgKtu3jnd/uknSXKq/\nOX1j8D/STmUTXaef6WT9Oe8oY91RxgkgaRfgBOA6278eqmwiSfBEREStco8nIiJqleCJiIhaJXgi\nIqJWCZ6IiKhVgiciImr1/wEMqCAMIRPpDgAAAABJRU5ErkJggg==\n",
      "text/plain": [
       "<matplotlib.figure.Figure at 0x2319a5cf9b0>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "city_count.plot(kind='barh')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}
